1、登录
mysql -u root -p
2、选择数据库
mysql>use mysql;
3、查看root的host
mysql>select 'host' from user where user='root';
4、将host修改为%
mysql>update user set host = '%' where user ='root';
5、刷新权限
mysql>flush privileges;
6、确认
mysql>select 'host' from user where user='root';
mysql -u root -p
2、选择数据库
mysql>use mysql;
3、查看root的host
mysql>select 'host' from user where user='root';
4、将host修改为%
mysql>update user set host = '%' where user ='root';
5、刷新权限
mysql>flush privileges;
6、确认
mysql>select 'host' from user where user='root';