登录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;