进入mysql:mysql -h127.0.0.1 -uroot -proot
mysql> use mysql;
mysql> update user set host = 'ip' where user = 'root';
mysql> select host, user from user;
mysql> flush privileges;
进入mysql:mysql -h127.0.0.1 -uroot -proot
mysql> use mysql;
mysql> update user set host = 'ip' where user = 'root';
mysql> select host, user from user;
mysql> flush privileges;