mysql 外部访问设置


1. 增加或者修改用户root的host为%,给与所有IP有访问权限。

mysql>use mysql; 

mysql>update user set host = ‘%’ where user =’root’; 
或者:
mysql>grant all privileges  on *.* to root@'%' identified by "password";

mysql>flush privileges; 
mysql>quit

[……]

继续阅读