Host XXX is not allowed to connect to this MySql 远程连接

1. 修改系统表

$mysql -u root -p rootmysql>use mysql; //使用MySQL数据库mysql>select host, user from user; //查看修改前的结果mysql>update user set host = '%' where user = 'root'; //修改表内容mysql>select host, user from user; //查看修改后的结果mysql>FLUSH PRIVILEGES; //使修改立即生效

2. 给用户授权

允许用户root使用密码root从任何主机连接mysql服务器：

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

允许用户root使用密码root从主机192.168.1.77连接mysql服务器：

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

允许用户root使用密码root从主机192.168.1.77连接mysql服务器的iep数据库：

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