Show slave status MySQL user permissions

I had a problem with granting correct MySQL user permissions to our in-house monitoring script. The problem was with MySQL user permissions that checked how many seconds behind the master is our MySQL slave server.

MySQL permissions you will need to set-up for the new user on the slave server are PROCESS and REPLICATION, it should work to execute “show slave status” command:

 

GRANT PROCESS, REPLICATION CLIENT ON dbname.* TO ‘monitoring’@’192.178.2.2’ IDENTIFIED BY ‘PWD_HERE’;


Leave a Reply