Page 1 of 1

SLAVE SERVER not connecting TO MASTER

Posted: Fri Jan 27, 2006 8:12 am
by mhouldridge
Hi,

I am trying to connect a replication server to a master server however when I start the slave, the connection fails with error connection to something.net using password YES.

Now I have created a user on the master of "repl@%" to allow any other host to connect. i have also specified the following within my mysql.ini file;

master-user = repl
master-password = something

Therefore I have specified a password however it doesnt appear to be using this although it does try the correct username.


Please help.

Posted: Fri Jan 27, 2006 10:12 am
by pickle
Have you set up the replication user properly on the master? Not only do you have to say the user can access from anywhere, but you also have to say the database can be accessed from anywhere. Also, make sure the replication user has the 'Repl_slave_priv' and 'Repl_client_priv' privileges set on the master.

Posted: Fri Jan 27, 2006 10:41 am
by mhouldridge
Hi,

Many thanks. I have everything working now.

Posted: Fri Jan 27, 2006 12:26 pm
by pickle
What was the fix? I'm interested now ;)