设置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;