1、连接数据库 mysql -u root -p
2、输入密码
3、select User, host from mysql.user;
4、use mysql;
5、update user set host='%' where host='localhost' and user='root';
6、查询是否设置成功 select user,host from user;
1、连接数据库 mysql -u root -p
2、输入密码
3、select User, host from mysql.user;
4、use mysql;
5、update user set host='%' where host='localhost' and user='root';
6、查询是否设置成功 select user,host from user;