MySQL Forums
Forum List  »  Install & Repo

Error_code: 1141 on replication slave
Posted by: Scott Rich
Date: September 08, 2004 06:17AM

I have replication setup between to windows hosts and have been fighting with the following error on the slave.

ERROR: 1141 There is no such grant defined for user 'support' on host 'pcmaint'

Slave: Error 'There is no such grant defined for user'support' on host 'pcmaint' on query. Default database: 'zorum'. Query: 'REVOKE ALL PRIVILEGES ON *.* FROM 'support@pcmaint', Error_code: 1141

Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'arcona-bin.004' position12442

My understanding is that the user accounts do not need to be configured on the slave server. Am I wrong? How do I fix this broken replication?

Options: ReplyQuote

Written By
Error_code: 1141 on replication slave
September 08, 2004 06:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.