远程连接Mysql,报错:ERROR 1130: Host XXX.XXX.XXX.XXX is not allowed to connect to this MySQL server
在要远程连接的机器上用命令行进入mysql:
mysql -u root -p;
use mysql;
grant all on *.*
to root identified by '密码'
with grant option;
flush privileges;
即可
感谢原文作者!
原文地址:http://my.oschina.net/maliang0130/blog/207823