mysql> use mysql;

Database changed

mysql> select host from user where user='root';

+------+

| host |

+------+

| % |

+------+

1 row in set (0.03 sec)

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

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)