Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
N/A
Description
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 |