Hi,

Does anyone know what privileges are required for a user to be able to
call statements that control replication?

Just to clarify exactly what I mean here:

I am writing a module to manage fail-over if a master db dies and would
ideally like to be able to run the app. without having to grant it
root-level privileges on the databases involved.

Replication is running happily enough using a dedicated replication user
with only sufficient privileges to read from a master and do the
necessary local writes.  I now want to create another user (say
repl_manager) to run commands like START or STOP SLAVE and RESET master
which I would like to grant only the necessary privileges...

...if only the docs said what they are.

Cheers,

Tom
-- 
Tom Acland
Partner

WesternReal OHG
Grosse SeestraÃe 32-34
60486 Frankfurt
Germany


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to