CODEWITHSUNDEEP
mysqldatabasereplication
user1052448
user1052448

Reputation: 433

MySQL Master/Master replication working only one way

I have two mysql databases. I want to do a master/master replication.

Replication is working one way. However, the other way it does not. The error states that it can't connect with user 'test@IPADDRESS'.

How can I change the username to repl? Never put in test, so not sure how it even trying to connect with that user. Doesn't exist in the user table either.

Upvotes: 0

Views: 821

Answers (1)

dwjv
dwjv

Reputation: 1227

You need the CHANGE MASTER TO command (run from the 'slave'). It's the MASTER_USER you're after.

Upvotes: 1

Related Questions