Slave DB setup

[Mad_Dog]

Hey All, I'm trying to setup a vicidial slaveDB, using the vicibox installer.
I have the user account setup on the master server DB and granted ALL PRIVILEGES to the account but when i run the setup and it tries to make the connection i get the below, any help would be great.

Vicibox installer V1-
Local SVN revision matches DB revision: 3666

mysqldump: Couldn't execute 'FLUSH /*!40101 LOCAL */ TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)
Could not get database dump from master: 512 at /usr/bin/vicibox-install line 280, <STDIN> line 20.

[williamconley]

granted ALL PRIVILEGES

Um ...

Code: Select all

GRANT RELOAD ON *.* TO 'your_user'@'localhost';

It's a fairly clear error message. TBH

[Mad_Dog]

Yeah, i agree its a clear error message, issue is that i have already given reload and "all privileges" to the account so its not that.

Actually sorted, it appears to use an additional account called slave which needs privileges changes, once i did that i got it working.

[carpenox]

great post back!