Leonard, What command are you using to start the slave server? I was thinking maybe it wasn't reading the correct configuration file?
This one is pretty strange. Have you thought about upgrading the slave mysql version, just to disregard that it might be a problem between the two versions? One thing, in your user table, are you using the hostname of the slave server to specify where it's coming from? ( I know you said you did % already, so this shouldn't matter.. but.. who knows? ). Here's what my replication user looks like - | % | bkup | password | N | N | N | N | N | N | N | N | N | Y | N | N | N | N | What do you currently have in the mysql 'user' table for the repl user? -- sh On Wed, 2002-03-27 at 17:18, Leonard Megliola wrote: > > Thanks Scott. It looks like permissions could be the issue, but checking > out the table shows that I have all of the correct permissions setup > exactly as you have listed them below. > > If you have any other ideas, I'd appreciate them. > > Thanks, > > Leonard > > At 12:49 PM 3/27/2002 -0500, you wrote: > >Leonard, > > > > This is pretty clearly (IMHO) a permissions issue. Make sure the > >username you use to replicate with, has a '%' in the Host field of the user > >table. > > > >mysql> use mysql > >mysql> select * from user where user = '<your_replication_user>' \G > >*************************** 1. row *************************** > > Host: % > > User: <your_replication_user> > > Password: <encrypted_password> > > Select_priv: N > > Insert_priv: N > > Update_priv: N > > Delete_priv: N > > Create_priv: N > > Drop_priv: N > > Reload_priv: N > > Shutdown_priv: N > > Process_priv: N > > File_priv: Y > > Grant_priv: N > >References_priv: N > > Index_priv: N > > Alter_priv: N > >1 row in set (0.01 sec) > > > > > >Scott Helms > >Director of Technology, ZCorum > > > > > >----- Original Message ----- > >From: "Leonard Megliola" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, March 27, 2002 12:16 PM > >Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? > > > > > > > > > > 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 > > > > > > > > >--------------------------------------------------------------------- > >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 > --------------------------------------------------------------------- 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
