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

CLONE - Slave user can't run "SHOW SLAVE STATUS" anymore after upgrade to 10.5, mysql_upgrade should take of that

    XMLWordPrintable

Details

    Description

      This is a clone of the original MDEV-23610

      This BUG is still not fixed. Although marked as closed. Found no way to reopen.... so created this clone.

      Easy steps to reproduce:

      SELECT VERSION();
      SELECT USER();
      GRANT REPLICATION CLIENT ON . TO 'CMDSYSTEM'@'%';
      SHOW GRANTS;
      SHOW SLAVE STATUS;

      =>

      10.5.13-MariaDB-log
      CMDSYSTEM@CAS-WS200115.caseris.intern
      GRANT BINLOG MONITOR ON . TO `CMDSYSTEM`@`%` IDENTIFIED BY PASSWORD '*something'

      Access denied; you need (at least one of) the SUPER, SLAVE MONITOR privilege(s) for this operation SQL.sql 10 1

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23899 admin privilege required to monitoring replication status - 10.5.5

          • Major - Major loss of function.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-21743 Split up SUPER privilege to smaller privileges

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-22030 Don't grant REPLICATION MASTER ADMIN automatically on upgrade from an older JSON user table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22152 REPLICATION MASTER ADMIN privilege not given to former SUPER users upon upgrade

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23918 admin privlege required to view contents of relay logs in 10.5

          • Major - Major loss of function.
          • Closed

          Activity

            People

              greenman Ian Gilfillan
              ThomasHuppertz Thomas Huppertz
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5d
                  0.5d

                  Git Integration

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