MySQL said: Host 'XXX' is not allowed to connect to this MySQL server

MySQL said: Host 'XXX' is not allowed to connect to this MySQL server

MySQL不允许远程登录

解决方法：

允许root用户从任何主机连接MySQL服务器

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;FLUSH PRIVILEGES;

允许root用户从“192.168.2.1”主机连接MySQL服务器

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.2.1' IDENTIFIED BY '123456' WITH GRANT OPTION;FLUSH PRIVILEGES;

允许root用户从“192.168.2.1”主机连接MySQL服务器中的test数据库

GRANT ALL PRIVILEGES ON db.test TO 'root'@'192.168.2.1' IDENTIFIED BY '123456' WITH GRANT OPTION;FLUSH PRIVILEGES;