Could not execute Update_rows event on table mysql.user； Duplicate entry ‘%-root‘ for key ‘PRIMARY‘

weixin_59693086

于 2024-07-06 17:52:53 发布

阅读量229

点赞数 1

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_59693086/article/details/140232729

版权

主从都开启了gtid，从库开启主从同步后，检查同步状态，出现以下报错信息：Could not execute Update_rows event on table mysql.user; Duplicate entry '%-root' for key 'PRIMARY'

原因分析：说明有多个ROOT用户纪录在USER表中了.

解决思路：

查看一下root用户是否重复了

mysql> select Host,User,authentication_string from mysql.user;
+-----------+-------------+-------------------------------------------+
| Host      | User        | authentication_string                     |
+-----------+-------------+-------------------------------------------+
| localhost | root        | *1F4EB9EF6A96C72C765E275B17155EF9A81A5A7F |
| %         | root        | *1F4EB9EF6A96C72C765E275B17155EF9A81A5A7F |
| localhost | mysql.sys   | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| %         | replication | *450237C29A0AFB94F3CE8A0AFC7458EA06F3CDDF |
+-----------+-------------+-------------------------------------------+
4 rows in set (0.00 sec)

查看host列root用户有%就是重复了

删除root@localhost