SLAVE MONITOR Privilege

Overview

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:

Grants ability to SHOW SLAVE STATUS, SHOW REPLICA STATUS, SHOW ALL SLAVES STATUS, SHOW ALL REPLICAS STATUS, SHOW RELAYLOG EVENTS. New privilege added in MariaDB Enterprise Server 10.5.8-5. Alias for REPLICA MONITOR.

In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

Not present

See also: Privileges in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

  • SLAVE MONITOR was added in ES10.5.8-5 and was not present in earlier releases. SLAVE MONITOR grants the ability to:

  • If a user upgrades from ES10.4 or earlier to ES10.5.8-5 or later, any users with REPLICATION CLIENT and REPLICATION SLAVE privileges will automatically be granted the REPLICA MONITOR privilege. This privilege upgrade happens upon server startup, so mysql_upgrade is not required.

  • The upgrade behavior does not apply to minor release upgrades that upgrade from ES10.5.6-4 or earlier ES10.5.x release to ES10.5.8-5 or later.

  • SLAVE MONITOR is an alias for REPLICA MONITOR which is also new in ES10.5.8-5.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Added in MariaDB Enterprise Server 10.5.8-5.

10.5 Community

  • Added in MariaDB Community Server 10.5.9.

10.4 Enterprise

  • Not present.

10.4 Community

  • Not present.

10.3 Enterprise

  • Not present.

10.3 Community

  • Not present.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

EXTERNAL REFERENCES