How is this possible?
On the master (v5.0.0, port 3306), we have +----------------------------------------------+ | Grants for [EMAIL PROTECTED] | +----------------------------------------------+ | GRANT REPLICATION SLAVE ON *.* TO '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 '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]
