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
