Hello,
I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files.... Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says "Can't connect to MySQL server on '0'" when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
