use mysql
show tables;
mysql> select host from user;
+-----------------------+
| host |
+-----------------------+
| 127.0.0.1 |
| localhost |
| localhost |
| localhost.localdomain |
| localhost.localdomain |
+-----------------------+
5 rows in set (0.00 sec)
mysql> update user set host='%' where user='root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1
mysql> select host from user where user='root';
+-----------------------+
| host |
+-----------------------+
| % |
| 127.0.0.1 |
| localhost.localdomain |
+-----------------------+
3 rows in set (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)