Linux下设置mysql允许远程连接

改表法，更改 mysql 数据库里的 user 表里的 host 项，从"localhost"改称"%"

1、root用户登录到mysql数据库

　　mysql -u root -p

输入密码进入mysql

 

2、依次执行

　　use mysql;

 

查看user表的情况

　　SELECT Host,User FROM user;

mysql> SELECT Host,User FROM user;
+-----------+-----------+
| Host      | User      |
+-----------+-----------+
| localhost | mysql.sys |
| localhost | root      |
+-----------+-----------+

 

更改

　　UPDATE user SET Host = '%' WHERE User= 'root' LIMIT 1;

 

刷新MySQL的系统权限相关表，使新设置生效

　　 flush privileges;

 

查看

mysql> SELECT Host,User FROM user;
+-----------+-----------+
| Host      | User      |
+-----------+-----------+
| %         | root      |
| localhost | mysql.sys |
+-----------+-----------+

修改成功