1.登陆mysql:
mysql -u root mysql
2.运行下面命令
UPDATE `mysql`.`user` SET `Host` = ‘%‘ WHERE `user`.`Host` = CAST( 0x6c6f63616c686f7374 AS BINARY ) AND `user`.`User` = CAST( 0x726f6f74 AS BINARY ) ;
3.重启mysql
service mysqld restart
原文：http://www.cnblogs.com/kangleweb/p/7478353.html