Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is.
Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: >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 > --------------------------------------------------------------------- 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
