(23000): Duplicate entry ‘%-root‘ for key ‘PRIMARY‘

如果执行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 |