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

SHOW CREATE USER generates invalid SQL (password expiry/ account lock)

    XMLWordPrintable

    Details

      Description

      MariaDB [(none)]> show create user 'mariadb.sys'@'localhost';
      +--------------------------------------------------------------------+
      | CREATE USER for mariadb.sys@localhost                              |
      +--------------------------------------------------------------------+
      | CREATE USER `mariadb.sys`@`localhost` PASSWORD EXPIRE ACCOUNT LOCK |
      +--------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> CREATE USER `mariadb.sys`@`localhost` PASSWORD EXPIRE ACCOUNT LOCK;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ACCOUNT LOCK' at line 1
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: