Hi I'm having strange yet serious problems with the new replication functions of mysql.
I have set up my /etc/my.cnf file correctly as far as I can see, yet when I start the slave I get the following errors in my error log:
010129 15:54:51 Slave thread: error connecting to master:Can't connect to MySQL
server on '0' (11)(107), retry in 0 sec
Strangely, when I do a SHOW SLAVE STATUS it reports that there is no master host, no master user, no master password and no reconnect period. BUT YET, it has read the replicate-do-db part of the my.cnf file. This is very strange. Can anyone help? I have followed instructions to the letter, and have doubled checked everything time and time again!
Thanks
Andrew Cuthbert
I have set up my /etc/my.cnf file correctly as far as I can see, yet when I start the slave I get the following errors in my error log:
010129 15:54:51 Slave thread: error connecting to master:Can't connect to MySQL
server on '0' (11)(107), retry in 0 sec
Strangely, when I do a SHOW SLAVE STATUS it reports that there is no master host, no master user, no master password and no reconnect period. BUT YET, it has read the replicate-do-db part of the my.cnf file. This is very strange. Can anyone help? I have followed instructions to the letter, and have doubled checked everything time and time again!
Thanks
Andrew Cuthbert