Permissions for a MySQL user which will monitor replication status?

Question

I'd like to use a script to monitor the replication status of a MySQL database like in this bash script: https://gist.github.com/wesdeboer/1791632

I'd like to create a user which will only be used to query the status of the replication. So basically this user would just need to run the command:

"SHOW SLAVE STATUS \G"

What is the minimum set of permissions I need to grant a user to allow this?

(Is this even something which can be GRANTed?

RolandoMySQLDBA · Accepted Answer · 2013-03-09 01:48:18Z

19

Either SUPER or REPLICATION CLIENT should do it. I would go with the minimum:

GRANT REPLICATION CLIENT ON *.* to user@host;

answered Mar 9, 2013 at 1:48

RolandoMySQLDBA

181k33 gold badges313 silver badges514 bronze badges

1

In recent versions of MariaDB you may need to use SLAVE MONITOR or REPLICA MONITOR instead of REPLICATION CLIENT
– Andy Beverley
Aug 5, 2022 at 13:05

Add a comment |

iaskakho · Accepted Answer · 2022-10-31 21:06:59Z

0

You have to also GRANT SELECT in order to connect.

answered Oct 31, 2022 at 21:06

iaskakho

11 bronze badge

3

SELECT on what exactly?
– mustaccio
Oct 31, 2022 at 22:03
I did Select on the table that was replicating, without the select grant it would not allow to connect to the database and raise an error. After SELECT was granted was able to connect no problem, could possibly be cuz of the version of the database, I was using Maria db 10.
– iaskakho
Jun 6 at 19:02

Add a comment |

2 Answers 2