远程连接时MySQL ERROR 1130 (HY000): Host ‘‘47.107.151.186‘‘ is not allowed to connect to this MySQL se...

本地连接服务器上MySQL数据库时遇到这个问题 MySQL ERROR 1130 (HY000): Host ‘‘47.107.151.186’’ is not allowed to connect to this MySQL server,解决办法就是把MySQL中的user表中的localhost改为%

连接MySQL数据库
[root@zengyemin mysql]# mysql -u root -p
Enter password: *******

mysql> use mysql;

mysql> update user set host=’’%’’ where host = ‘‘localhost’’;

mysql> select host,user from user;
±----------±-----+
| host | user |
±----------±-----+
| % | root | #原本%是localhost
| 127.0.0.1 | root |
| ::1 | root |
| zengyemin | |
| zengyemin | root |

mysql> flush privileges;
问题解决