MySQL replication

Discussion in 'HOWTO-Related Questions' started by 3molo, May 15, 2007.

  1. 3molo

    3molo New Member

    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.
     
    Last edited: May 15, 2007
  2. 3molo

    3molo New Member

    Solution was:

    grant all privileges on *.* to root@localhost; flush privileges;
    Thanks anyway.
     
  3. nephish

    nephish New Member

    Hey thanks for this, helped me out.
     

Share This Page