Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
Since 10.5, variables for binlog configuration require BINLOG ADMIN privilege, not SUPER. I think the same should apply to the new max_binlog_total_size and slave_connections_needed_for_purge variables, too.
bb-11.4-timestamp 53df87b27d9e0c0e7e5f2e2e7e5aabd86aa20bee |
MariaDB [(none)]> show grants for current_user(); |
+------------------------------------------------------+ |
| Grants for binlogger@localhost | |
+------------------------------------------------------+ |
| GRANT BINLOG ADMIN ON *.* TO `binlogger`@`localhost` | |
+------------------------------------------------------+ |
1 row in set (0.000 sec) |
|
MariaDB [(none)]> set global max_binlog_size= 1024*1024; |
Query OK, 0 rows affected (0.000 sec) |
|
MariaDB [(none)]> set global max_binlog_total_size= 1024*1024; |
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation |
MariaDB [(none)]> set global slave_connections_needed_for_purge= 0; |
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation |
MariaDB [(none)]> show grants for current_user(); |
+----------------------------------------------+ |
| Grants for superman@localhost | |
+----------------------------------------------+ |
| GRANT SUPER ON *.* TO `superman`@`localhost` | |
+----------------------------------------------+ |
1 row in set (0.000 sec) |
|
MariaDB [(none)]> set global max_binlog_size= 1024*1024; |
ERROR 1227 (42000): Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation |
MariaDB [(none)]> set global max_binlog_total_size= 1024*1024; |
Query OK, 0 rows affected (0.000 sec) |
|
MariaDB [(none)]> set global slave_connections_needed_for_purge= 0; |
Query OK, 0 rows affected (0.000 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-31404 Implement binlog_space_limit
- Closed