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.
SLAVE SERVER not connecting TO MASTER
Moderator: General Moderators
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am
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.
- mhouldridge
- Forum Contributor
- Posts: 267
- Joined: Wed Jan 26, 2005 5:13 am