默认用户是通过localhost访问的。
登陆mysql后,切换到mysql数据库,修改user表中指定用户的host字段内容。
USE mysql;SELECT USER, HOST FROM USER WHERE USER ='root';UPDATE USER SET HOST = '%' WHERE USER ='root';FLUSH PRIVILEGES;
或者
Grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;flush privileges;