Ubuntu中 Mysql 远程登录的解决方法

mysql>use mysql;

 

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

 

 

重启Mysql

 

sudo /etc/init.d/mysql restart

 

[sudo] password for wangzw:

 

*Stopping MySQL database server mysqld                          [OK]

 

*Starting  MySQL database server mysqld                          [OK]

 

*Checking for corrupt, not cleanly closed and updatade needing tables.