|
https://mariadb.com/kb/en/grant/#replication-slave-admin
Permits administering replica servers, including START REPLICA/SLAVE, STOP REPLICA/SLAVE, CHANGE MASTER, SHOW REPLICA/SLAVE STATUS, SHOW RELAYLOG EVENTS statements, replaying the binary log with the BINLOG statement
|
10.6 70021737
|
MariaDB [test]> show grants;
|
+---------------------------------------------------+
|
| Grants for rpl@% |
|
+---------------------------------------------------+
|
| GRANT REPLICATION SLAVE ADMIN ON *.* TO `rpl`@`%` |
|
+---------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> binlog '*foo';
|
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER, BINLOG REPLAY privilege(s) for this operation
|
MariaDB [test]> show grants;
|
+--------------------------------------------------------------------------+
|
| Grants for slave_admin@% |
|
+--------------------------------------------------------------------------+
|
| GRANT REPLICATION SLAVE ADMIN, BINLOG REPLAY ON *.* TO `slave_admin`@`%` |
|
+--------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> show slave status;
|
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER, SLAVE MONITOR privilege(s) for this operation
|
|