3molo
15th May 2007, 19:45
Hey forum!
I followed the guide for Mysql master/slave replication and everything works but "LOAD DATA FROM MASTER;". Also the slave does not get updated on its own.
Here's my error:
ERROR 1219 (HY000): Error running query on master: Access denied; you need the RELOAD privilege for this operation
I did the GRANT REPLICATION and everything on the master (for the slave_user).
With logging turned on at the master mysql, trying the LOAD DATA FROM MASTER; on the slave only gave me:
373 Connect slave_user@localhost on
373 Query SHOW DATABASES
373 Query FLUSH TABLES WITH READ LOCK
from the logfile of the mysql master.
How to allow this RELOAD privilege for slave_user?
Thanks in advance, 3molo.
I followed the guide for Mysql master/slave replication and everything works but "LOAD DATA FROM MASTER;". Also the slave does not get updated on its own.
Here's my error:
ERROR 1219 (HY000): Error running query on master: Access denied; you need the RELOAD privilege for this operation
I did the GRANT REPLICATION and everything on the master (for the slave_user).
With logging turned on at the master mysql, trying the LOAD DATA FROM MASTER; on the slave only gave me:
373 Connect slave_user@localhost on
373 Query SHOW DATABASES
373 Query FLUSH TABLES WITH READ LOCK
from the logfile of the mysql master.
How to allow this RELOAD privilege for slave_user?
Thanks in advance, 3molo.