Replication on my slave database (MySQL 5.7.12) stopped working suddenly. When I run
SHOW SLAVE STATUS\G I see the following error:
Last_Errno: 1396 Last_Error: Error 'Operation CREATE USER failed for 'user'@'ip'' on query. Default database: ''. Query: 'CREATE USER 'user'@'ip' IDENTIFIED WITH 'mysql_native_password' AS '*password''
I had recently created 2 new read-only users on both my master and my slave so I'm certain it's because of this.
I also see this in the status:
Slave_IO_Running: Yes Slave_SQL_Running: No
Any suggestions on how to fix this?