通过更改mysql的user表实现数据库异地连接/外网连接

1.登录数据库

mysql -u root -p
Enter password: #输入mysql密码

2. 查看自带的mysql数据库的user表

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

可以看到

+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
+-----------------------+------+-------------------------------------------+

3.更改user表实现远程连接
将host字段的值改为%就表示在任何客户端机器上能以root用户登录到mysql服务器，建议在开发时设为%。

update user set host = ’%’ where user = ’root’;

4.查看user是否发送变化

mysql>  select host,user,password from user;
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| %                     | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
+-----------------------+------+-------------------------------------------+

5.刷新配置

flush privileges;

6.尝试使用宿主机的sqlyon连接，成功。