Bug #80 Obscure error message in replication (Error updating slave list: Query error)
Submitted: 17 Feb 2003 9:51 Modified: 11 Mar 2003 5:54
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.0 OS:Any (all)
Assigned to: Guilhem Bichot CPU Architecture:Any

[17 Feb 2003 9:51] Guilhem Bichot
While setting up replication, if one forgets to GRANT REPLICATION SLAVE to the replication user, then does START SLAVE,
he gets this in the error log :
> 4:36:30  Error updating slave list: Query error
Which is not very clear.

How to repeat:
GRANT USAGE on *.* to the_replication_user
on the master
and forget to grant REPLICATION SLAVE.

Suggested fix:
I have a patch that prints something like :

The replication user used by the slave failed updating the slaves' list on the master ; while doing SHOW SLAVE HOSTS on the master he got this error:
"Access denied. You need the REPLICATION SLAVE privilege for this operation"

I will send it in a big patch for #52,#53,#70,#79 together.
[11 Mar 2003 5:54] Guilhem Bichot
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 

this is fixed in changeset 1.1645