MySQL Forums :: Utilities :: mysqlreplicate adds user during setup; replication fails.


Advanced Search

Re: mysqlreplicate adds user during setup; replication fails.
Posted by: Jerry Richart ()
Date: March 14, 2016 09:49AM

The statement failed with "ERROR 1396 (HY000): Operation CREATE USER failed for 'repl_slave_user'@'ptwmys04'".
so ...
I "flushed privileges" and tried again. It worked. My next step was to revoke all privileges for the user on both the master and the slave and then drop the user. I flushed the privileges on both servers and was able to successfully resync the slave with the master.

Thanks for your help, Rick.

Jerry

Jerry Richart
Database Administrator for Microsoft SQL Server and MySQL.

Stand Out! Be a beacon for others to follow.

Options: ReplyQuote


Subject Views Written By Posted
mysqlreplicate adds user during setup; replication fails. 1408 Jerry Richart 03/11/2016 01:29PM
Re: mysqlreplicate adds user during setup; replication fails. 472 Rick James 03/12/2016 11:08PM
Re: mysqlreplicate adds user during setup; replication fails. 475 Rick James 03/12/2016 11:09PM
Re: mysqlreplicate adds user during setup; replication fails. 470 Jerry Richart 03/14/2016 09:51AM
Re: mysqlreplicate adds user during setup; replication fails. 483 Jerry Richart 03/14/2016 09:49AM


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.