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

Possible bug in CREATE USER

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.6.12
    • N/A
    • Server
    • None

    Description

      MariaDB [(none)]> CREATE USER 'blocklists
          '> ,
          '> ;
          '> ;
          '> ';
      Query OK, 0 rows affected (0.011 sec)
       
      MariaDB [(none)]> DROP USER blocklists;
      ERROR 1396 (HY000): Operation DROP USER failed for 'blocklists'@'%'
       
      MariaDB [(none)]> SELECT user,host FROM mysql.user;
      +-------------------+-----------+
      | User              | Host      |
      +-------------------+-----------+
      | blocklists
      ,
      ;
      ;
       | %         |
      | mariadb.sys       | localhost |
      | mysql             | localhost |
      | root              | localhost |
      +-------------------+-----------+
      4 rows in set (0.001 sec)
       
      MariaDB [(none)]> DROP USER 'blocklists%'@'%';
      ERROR 1396 (HY000): Operation DROP USER failed for 'blocklists%'@'%'
       
      MariaDB [(none)]> DROP USER 'blocklists
      ,
      ;
      ;'@'%';
      ERROR 1396 (HY000): Operation DROP USER failed for 'blocklists\n,\n;\n;'@'%'
       
      MariaDB [(none)]> DROP USER 'blocklists,;;'@'%';
      ERROR 1396 (HY000): Operation DROP USER failed for 'blocklists,;;'@'%'
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            acs-ferreira acsfer
            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.