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

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