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)