#1  
Old 15th May 2007, 18:45
3molo 3molo is offline
Junior Member
 
Join Date: Oct 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL replication

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 by 3molo; 15th May 2007 at 18:51.
Reply With Quote
Sponsored Links
  #2  
Old 15th May 2007, 20:06
3molo 3molo is offline
Junior Member
 
Join Date: Oct 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Solution was:

grant all privileges on *.* to root@localhost; flush privileges;
Thanks anyway.
Reply With Quote
  #3  
Old 23rd May 2007, 22:31
nephish nephish is offline
Junior Member
 
Join Date: May 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hey thanks for this, helped me out.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
MySQL Replication neil6179 Server Operation 1 12th September 2006 15:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 11:49.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.