use mysql; select host,user from user;
update user set host='%' where user ='root';
FLUSH PRIVILEGES;
原文链接