Faqts : Business : Databases : MySQL : Installation and Setup : Replication

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

10 of 16 people (63%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

What does the "Error updating slave list: query error" mean?

Dec 6th, 2002 11:43
BigBoots McTiernan, Reboot boot,


This can happen if the slave user doesn't have the proper permission to
connect to the master.

First, run the mysql_fix_privilege_tables script if you have upgraded
from an older version of MySQL.

Then, grant the slave user either "REPLICATION SLAVE" (MySQL 4.0.2 or
newer) or "FILE" (older versions) privilege, as described in the manual
section 4.10.3.