1.登陆到数据库 mysql -u root -p 2.输入:use mysql; 3.输入:update user set host = '%' where user = 'root' and host='localhost'; 4.输入查看:select host, user from user; 5.保存:mysql>flush rivileges 6.退出后重启:service mysql restar
1.登陆到数据库 mysql -u root -p 2.输入:use mysql; 3.输入:update user set host = '%' where user = 'root' and host='localhost'; 4.输入查看:select host, user from user; 5.保存:mysql>flush rivileges 6.退出后重启:service mysql restar