List:General Discussion« Previous MessageNext Message »
From:Toan. Dang Anh Date:July 30 2007 9:44am
Subject:RE: grants
View as plain text  
Grant user for slave:
 GRANT  REPLICATION SLAVE, REPLICATION CLIENT, RELOAD, SUPER on *.* TO
'username'@'IP Slave' IDENTIFIED BY 'password';

ToanDA
-----Original Message-----
From: Ananda Kumar [mailto:anandkl@stripped] 
Sent: Tuesday, July 03, 2007 8:59 PM
To: MySQL General
Subject: grants

Hi All,
We have setup replication for our production database. We need to do
monitoring of the slave and master.
I created a user with only "SELECT" privileges, and when i do "show
master
status" on master db, its saying
"Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
operation".

Is it necessary to grant "SUPER" privilages, or can i do it in some
other
way, without super privilages. This user is just for monitoring.

regards
anandkl
Thread
RE: grantsToan. Dang Anh30 Jul