1.一般是为使用下面的命令

Mysql>use mysql;

Mysql>update user set host='%' where user='root';

Mysql>flush privileges

2.也可以执行下面命令

USE mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

flush privileges;

3.最后查看主机栏是否为%

Mysql> select host,user from user;