At 19:57 -0600 3/19/04, Peter Brawley wrote:
On logging in as user repl, current_user()[EMAIL PROTECTED] The user
table row for user=repl has host=% as specified. There are no other
rows for user=repl. Is the manual incorrect in recommending this?
No. But it does mean you have an anonymous-user account that has a more
specific hostname part than the 'repl'@'%' account. Hostname matching
happens before username matching, and it appears that when your slave
connects to the master, it's being authenticated as ''@'localhost'.
I suggest you delete the anonymous-user account (do you really need it?),
flush the privileges, and try again.
Alternatively, change your replication account to 'repl'@'localhost'.
Do you really want 'repl' to be able to connect from any host?
----- Original Message -----
From: <mailto:[EMAIL PROTECTED]>Paul DuBois
To: <mailto:[EMAIL PROTECTED]>Peter Brawley ;
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Sent: Friday, March 19, 2004 7:27 PM
Subject: Re: master cannot find replication slave privilege
At 15:19 -0600 3/19/04, Peter Brawley wrote:
How is this possible?
On the master (v5.0.0, port 3306), we have
+----------------------------------------------+
| Grants for <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] |
+----------------------------------------------+
| GRANT REPLICATION SLAVE ON *.* TO <mailto:'repl'@'%'>'repl'@'%' |
+----------------------------------------------+
The slave server (v5.0.0.a, port 3307) accepts ...
CHANGE MASTER TO
master_host='localhost',
master_port=3306,
master_user='repl',
master_log_file= 'toshnb-bin.000033',
master_log_pos=582;
but in response to
START SLAVE
the slave server reports ...
040319 15:01:17 While trying to obtain the list of slaves
from the master 'localhost:3306', user 'repl' got the following error:
'Access denied. You need the REPLICATION SLAVE privilege for this operation'
040319 15:01:17 Slave I/O thread exiting, read up to log
'toshnb-bin.000033',
position 582
Connect manually to the server (using mysql, for example) specifying
repl as your username, then issue this query:
SELECT CURRENT_USER();
Does it show that you were authenticated as <mailto:'repl'@'%'>'repl'@'%'?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
