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

            Assignee:
            Unassigned
            Reporter:
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: