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:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	4.0	OS:	Any (all)
Assigned to:	Guilhem Bichot	CPU Architecture:	Any

Description:
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:
do
GRANT USAGE on *.* to the_replication_user
on the master
and forget to grant REPLICATION SLAVE.
Then 
START 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.

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 
    http://www.mysql.com/doc/en/Installing_source_tree.html

this is fixed in changeset 1.1645

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.