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

SHOW CREATE USER generates invalid SQL

    XMLWordPrintable

    Details

      Description

      MariaDB [(none)]> show create user;
      +---------------------------------------------------------------------------------------------------+
      | CREATE USER for dan@localhost                                                                     |
      +---------------------------------------------------------------------------------------------------+
      | CREATE USER `dan`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket |
      +---------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]>  CREATE USER `dan2`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket
          -> ;
      ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
      

      Is "invalid" something that should be literally accepted for compatibility?

      To not do so means programs and humans that use SHOW CREATE USER output needs to parse out this text and remove it.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: