Updated privileges for MariaDB 10.5+

Napsty / check_mysql_slavestatus

Monitoring plugin to check the Status of a MySQL/MariaDB replication slave

15 stars 15 forks source link

Updated privileges for MariaDB 10.5+ #17

Closed aj-gh closed 1 year ago

aj-gh commented 1 year ago

Since MariaDB 10.5+ the REPLICA MONITOR privilege needs to be used to be able to fetch replication status; previously this was REPLICATION CLIENT. Additionally the suggested source-specification of "any" (%) in script and documentation seems a bit broad.

Napsty commented 1 year ago

Confirmed, setting the privilege SLAVE MONITOR (which is an alias for REPLICA MONITOR) works. Tested on MariaDB 10.6.