MySQL Bugs: #9066: Slave cannot get list of slaves from Master

Bug #9066	Slave cannot get list of slaves from Master
Submitted:	9 Mar 2005 6:53	Modified:	6 May 2005 18:39
Reporter:	Shawn Mullen	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S1 (Critical)
Version:	4.1.10	OS:	Windows (WIN2000/2003)
Assigned to:		CPU Architecture:	Any

Description:
Master is on WIN2003, slave on WIN 2000.

When the slave is started it attempts to connect to the master.  it is able to connect but it is unable to get the list of slaves from the master. Below is the error in the slave's log:

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.10-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)
050308 23:38:45 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\primary-relay-bin.000039' position: 4
050308 23:38:49 [Note] Slave I/O thread: connected to master 'repl@www2.****.com:3306',  replication started in log 'FIRST' at position 4
050308 23:38:49 [ERROR] While trying to obtain the list of slaves from the master 'www2.****.com:3306', user 'repl' got the following error: 'Access denied; you need the REPLICATION SLAVE privilege for this operation'
050308 23:38:49 [ERROR] Slave I/O thread exiting, read up to log 'FIRST', position 4

I have granted REPLICATION SLAVE to the repl user on the master.

How to repeat:
Setup replication

Could you please provide your my.ini master and slave. I wasn't able to repeat
between 2 XP boxes.

Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hello,
I understand that this report is very old, and maybe i should report a new bug or something, but i am getting almost the same error on 2 servers: 1 debian server and one WinXPPro server both running MySQL 5.0.11. GPL The 2 servers are replication master/slave <--> master/slave through a (bad) VPN connection. The error:

060301 10:01:40 [ERROR] While trying to obtain the list of slaves from the master '10.0.3.7:3306', user 'repl' got the following error: 'Lost connection to MySQL server during query'
060301 10:01:40 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 98

It happens on both servers, it occurs randomly, the average is 8 day's of uptime. the only way to start the master/slave <--> master/slave replication again is to stop the exited slave and start it again manually.

i can not skip this error because it has no "regular" number. 

I really searched everywhere, couldn't find anything that leads to a solution. Maybe trough this way? 
thanx for any reaction!

Hans

run command-line bash script called mysql_fix_privilege_tables against the master database.