MySQL1130错误 Host’123.1.1.1’ is not allowed to connect to this MySQL server

错误号码1130
Host’123.1.1.1’ is not allowed to connect to this MySQL server
不要慌，第一步先进入数据库服务器，然后打开命令行窗口，输入
mysql -hlocalhost -uroot -p
输入密码
然后输入
use mysql;
切换至database mysql
执行如下语句
flush privileges;
如果不行，那就执行下面的语句
select host from user where user=‘root’;
update user set host = ‘%’ where user =‘root’;
flush privileges;
select host from user where user=‘root’;
可以发现host发生了变化，有一行显示%就说明成功了