mysql -u root -p
mysql;use mysql;
mysql;select ‘host‘ from user where user=‘root‘;
mysql;update user set host = ‘%‘ where user =‘root‘;
mysql;flush privileges;
mysql 1130 ERROR 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server
原文：http://www.cnblogs.com/lvlv/p/3920020.html