Mysql 远程登录设置
2013/04
29
22:04
mysql -u root -p–>输入密码use mysql;
mysql> select host, user from user;
将相应用户数据表中的host字段改成’%’；
update user set host=’%’ where user=’root’;
ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’ 不予理会
flush privileges;
重新远程连接OK
navicat连接数据报10060错误，检查防火墙，开放3306端口
CopyRights: The Post by BY-NC-SA For Authorization，Original If Not Noted，Reprint Please Indicate From NewMiniSoft
Post Link: Mysql 远程登录设置
Post Link: Mysql 远程登录设置
发表回复