远程连接mysql出现ERROR 1130 (HY000): Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MySQL server

问题：

        远程连接服务器mysql出现：

        ERROR 1130 (HY000): Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MySQL server

 

解决：

1.命令行输入 ：mysql -u -root -p

   然后输入密码

2.然后输入sql语句：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '数据库密码' WITH GRANT OPTION;

3.接着输入语句：flush privileges;

 

最后：完事~