/usr/local/mysql/bin/mysql -u root -p (进入mysql)
use mysql;
SELECT `Host`,`User` FROM user;
UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
flush privileges;
注意在mysql 命令行形式下一定要输入";".
本文转自zsaisai 51CTO博客,原文链接:http://blog.51cto.com/3402313/938694