SLAVE SERVER not connecting TO MASTER

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

SLAVE SERVER not connecting TO MASTER

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
mhouldridge
Forum Contributor
Posts: 267
Joined: Wed Jan 26, 2005 5:13 am

Post by mhouldridge »

Hi,

Many thanks. I have everything working now.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

What was the fix? I'm interested now ;)
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply