mysql 更改host老出错？

mytangyou

mysql> select host,user,password from user;
+-----------+-------+------------------+
| host      | user  | password         |
+-----------+-------+------------------+
| %         | root  | 093afd266982ae9f |
| host32    | root  |                  |
| 127.0.0.1 | root  |                  |
| localhost |       |                  |
| host32    |       |                  |
| localhost | admin | 093afd266982ae9f |
| %         | admin | 093afd266982ae9f |
| localhost | otrs  | 7ae97445221f6f74 |
+-----------+-------+------------------+
8 rows in set (0.00 sec)

mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1
mysql>

yumanifold

晕。。。看到user处有几个root啊。。。

gamester88

1. mysql> update user set host='%' where user='host';
   
2. Query OK, 0 rows affected (0.00 sec)
   
3. Rows matched: 0  Changed: 0  Warnings: 0
   

复制代码

witer666

host user两个字段做主键！