Mysql 5.7 replication failure with alter user

Hi Team,

We have a master slave setup with mysql 5.7. When we alter the user on master with ALTER USER the replication gets breakdown with following error. Is there a way to avoid this. Because any user tries to reset the password this replication got breakdown.

Last SQL error: Error ‘Operation ALTER USER failed for ‘xxxxxxx’@’%’’ on query. Default database: ‘xxxxxxx’. Query: ‘ALTER USER ‘xxxxxxx’@’%’ IDENTIFIED WITH ‘mysql_native_password’ AS ‘*xxxxxxxxxxxxxxxxxxx’’

Thanks
Kumar

Verify that the users exist on the replica. Use pt-table-sync to synchronize the mysql.user table between master and replica.

1 Like