MySql出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
来源:互联网 发布:360软件管家字体模糊 编辑:程序博客网 时间:2024/06/05 19:50
如果执行update语句时出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 错误,说明有多个ROOT用户纪录在USER表中了.
需要select host from user where user = 'root';
查看一下host是否已经有了%这个值,有了就可以了.
mysql> select host,user from user where user='root';
+-----------------------+------+
| host | user |
+-----------------------+------+
| % | root |
| 127.0.0.1 | root |
| ::1 | root |
| localhost.localdomain | root |
阅读全文
0 0
- MySQL ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
- MySql出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
- ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
- MySQL --- SQL Error: 1062: Duplicate entry '2147483647' for key 'PRIMARY'
- ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'
- ERROR 1062 (23000): Duplicate entry '5' for key 'PRIMARY'
- txt导入Mysql:ERROR 1062(23000):Duplicate entry '0' for key 'PRIMARY'
- mysql数据库:ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'
- Mysql错误提示:Error: Duplicate entry '0' for key 'PRIMARY'
- mysql出现Duplicate entry '0' for key 'PRIMARY'的错误
- MySQL中出现Duplicate entry 'XXX' for key 'PRIMARY'解决方案
- mysql #1062 –Duplicate entry '1' for key 'PRIMARY'
- 异常:mysql 1062 –Duplicate entry '1' for key 'PRIMARY'
- mysql #1062 –Duplicate entry '1' for key 'PRIMARY'
- Duplicate entry '##' for key 'PRIMARY'
- .NET 操作 MySql 时,出现Duplicate entry '0' for key 'PRIMARY'问题解决办法
- Mysql错误:Duplicate entry '127' for key 'PRIMARY'的解决方法
- MySQL:Duplicate entry '1-2' for key 'PRIMARY' 错误
- python_文件操作
- 模版类型推导
- jdk环境变量配置
- snmp 安装及其信息采集
- scikit-learn linearRegression 1.1.9 贝叶斯回归
- MySql出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
- Java经典算法40例(十一)
- 浅谈 Node.JS (一 基础知识)
- 算法-快速排序算法
- Python基本数据类型
- springmvc 中@Controller和@RestController的区别
- Python学习笔记之文件(一)
- Java经典算法40例(十二)
- android基础知识---ActivityLifecycleCallbacks监听Activity们的生命周期