Grant user for slave:
GRANT REPLICATION SLAVE, REPLICATION CLIENT, RELOAD, SUPER on *.* TO
'username'@'IP Slave' IDENTIFIED BY 'password';
From: Ananda Kumar [mailto:anandkl@stripped]
Sent: Tuesday, July 03, 2007 8:59 PM
To: MySQL General
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
status" on master db, its saying
"Access denied; you need the SUPER,REPLICATION CLIENT privilege for this
Is it necessary to grant "SUPER" privilages, or can i do it in some
way, without super privilages. This user is just for monitoring.
|• RE: grants||Toan. Dang Anh||30 Jul|