設(shè)置mysql允許遠(yuǎn)程訪問

連接數(shù)據(jù)庫修改對(duì)應(yīng)表

mysql -u root -p;

use mysql;

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

select host,user from user;

flush privileges;

最后一句目的是使修改生效，如果沒有寫，則還是不能進(jìn)行遠(yuǎn)程連接。

授權(quán)用戶，允許從任何主機(jī)連接到mysql數(shù)據(jù)庫。

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

flush privileges;

只允許用戶從ip為x.x.x.x的主機(jī)連接到mysql服務(wù)器。

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;