MySQL> update user set host='%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
然后查看了下数据库的host信息如下：
MySQL> select host from user where user = 'root';
+-----------------------+
| host |
+-----------------------+
| % |
| 127.0.0.1 |
| localhost.localdomain |
+-----------------------+
3 rows in set (0.00 sec)
host已经有了%这个值，所以直接运行命令：
复制代码 代码如下:
MySQL>flush privileges;
再用MySQL administrator连接...成功！！
MySQL> update user set host='%' where user = 'root';ERROR...
记一次线上update数据报错ERROR 1062 (23000): Duplicate entry '1764-...
SQLSTATE[23000]: Integrity constraint violation: 1062 Dup...
一、报错：pymysql.err.IntegrityError: (1062, "Duplicate entry ...
SQL 字段添加自增报错 [23000][1062] ALTER TABLE causes auto_increm...
1062 - Duplicate entry '0' for key 'PRIMARY'原因： 主键没有设置id自...
ProblemWrite a SQL query to delete all duplicate email en...
一、解决Multiple commands produced error xcode 10 [duplicate]...
错误：line 32 Duplicate item error and crash原因：AllNotesSecti...
Internal Server Error Internal Server Error The server en...
本文标题：ERROR 1062 (23000): Duplicate en
本文链接：https://www.haomeiwen.com/subject/udxolxtx.html
网友评论