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

Upgrade to 10.5.9 breaks root's ability to grant

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.5.9
    • 10.5.10
    • Server
    • None
    • Ubuntu Focal
      10.5.9-MariaDB-1:10.5.9+maria~focal-log

    Description

      Upon upgrading from 10.5.8 to 10.5.9 root can no longer grant all.

      grant all on . to fred@localhost \G
      ERROR 1698 (28000): Access denied for user 'root'@'localhost'

      The root grants have changed on 10.5.9

       
      MariaDB [(none)]> show grants for root@'localhost'\G
      *************************** 1. row ***************************
      Grants for root@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, BINLOG MONITOR, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, DELETE HISTORY, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, REPLICATION MASTER ADMIN, BINLOG ADMIN, BINLOG REPLAY ON *.* TO `root`@`localhost` IDENTIFIED VIA unix_socket WITH GRANT OPTION
      *************************** 2. row ***************************
      Grants for root@localhost: GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
      2 rows in set (0.000 sec)
       
      Previously on 10.5.8
       
      MariaDB [(none)]> show grants for root@localhost\G*************************** 1. row ***************************
      Grants for root@localhost: GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA unix_socket WITH GRANT OPTION
      *************************** 2. row ***************************
      Grants for root@localhost: GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
      2 rows in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            26d 11h 50m 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            23d 15h 55m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            2s 1
            Sergei Golubchik made transition -
            Stalled Closed
            1d 2h 18m 1

            People

              serg Sergei Golubchik
              rwky Rowan Wookey
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.