Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33319

max_binlog_total_size and slave_connections_needed_for_purge require wrong permissions

    XMLWordPrintable

Details

    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

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.