Host ‘’###‘’ is not allowed to connect to this MySQL server

登录mysql查看user表

mysql> use mysql mysql> select host,user,password from user;

发现host只有localhost

mysql> select host,user,password from user; +-----------------------+------+-------------------------------------------+ | host                  | user | password                                  | +-----------------------+------+-------------------------------------------+ | localhost             | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | localhost.localdomain | root |                                           | | 127.0.0.1             | root |                                           | | localhost             |      |                                           | | localhost.localdomain |      |                                           | +-----------------------+------+-------------------------------------------+ 5 rows in set (0.00 sec)

修改host

---可能会报错是正常的，运行完发现能正常连接 mysql> update user set host = '%' where user = 'root'; ---刷新 mysql> FLUSH PRIVILEGES;

参考：https://www.cnblogs.com/vathena/p/4012399.html