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

cannot GRANT on newly created self (DROP USER me; CREATE USER me; GRANT .. TO me)

    XMLWordPrintable

Details

    Description

      MariaDB [(none)]> show create user;
      +--------------------------------+
      | CREATE USER for root@localhost |
      +--------------------------------+
      | CREATE USER 'root'@'localhost' |
      +--------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> drop user root@localhost;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> create user root@locahost identified by 'sugar plum fairy';
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> grant all on test.* to root@localhost;
      ERROR 1133 (28000): Can't find any matching row in the user table
       
      MariaDB [(none)]> select version();
      +-----------------+
      | version()       |
      +-----------------+
      | 10.2.38-MariaDB |
      +-----------------+
      1 row in set (0.00 sec)
      

      Expected behaviour, grant should be allowed.

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.