设置mysql允许远程访问

设置mysql允许远程访问

连接数据库修改对应表

mysql -u root -p;

use mysql;

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

select host,user from user;

flush privileges;

最后一句目的是使修改生效，如果没有写，则还是不能进行远程连接。

授权用户，允许从任何主机连接到mysql数据库。

grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;

flush privileges;

只允许用户从ip为x.x.x.x的主机连接到mysql服务器。

grant all privileges on *.* to 'root'@'%x.x.x.x' identified by '你的密码' with grant option;

flush privileges;

举例：

mysql -u root -p;

use mysql;

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

grant all privileges on *.* to 'root'@'%' identified by 'HeYiChen@17791' with grant option;

flush privileges;