Error 'Operation CREATE USER failed for'XXX'@'localhost'' on query

[Victor Alekseev]

Users were added (Master and Slave server), after starting replication. There was an error.

Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_Error: Error 'Operation CREATE USER failed for 'xxxxx'@'localhost'' on query. Default database: ''. Query: 'CREATE USER 'xxxxx'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx''

Solution to the problem:

STOP SLAVE;
RESET SLAVE;
CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xxx, MASTER_USER='xxxxxx, MASTER_PASSWORD='xxxxx',
MASTER_LOG_FILE = 'mysql-bin.0000xx', MASTER_LOG_POS = xxx;
START SLAVE;

Replication worked.

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

But when comparing databases through mysqldiff. Some tables were missing.