Hello all,
I noticed that my two Mysql slave servers were running out of sync this
morning. After looking into it...it appears that yesterday when I tried
to change the username of a user on the master server...it caused some
issues on the slaves. Here is what I was able to pull from the slave
error logs:
090108 16:46:05 [ERROR] Slave SQL: Error 'Operation CREATE USER failed
for 'root'@'127.0.0.1'' on query. Default database: 'mysql'. Query:
'CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD
'*3313E27C7AD7F792A60D5D651029375E60'', Error_code: 1396
090108 16:46:05 [Warning] Slave: Operation CREATE USER failed for
'root'@'127.0.0.1' Error_code: 1396
090108 16:46:05 [ERROR] Error running query, slave SQL thread aborted.
Fix the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'master-bin.000008' position 970652826
Can anyone tell me if/how I can remove that statement from the log
file...so I can restart the slave?
Is there a better way to fix this?
Thanks,
Shain
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
