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

mysqldump --system=users password_last_changed not saves MariaDB-10.4+, MySQL-5.7+

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.16
    • 10.4
    • None
    • None

    Description

      As part of password expiry, global_priv now has a password_last_updated field.

      This isn't exposed in any native SQL like 'SHOW CREATE USER', nor is it set-able except by modifying system tables directly.

      Without this feature, a restore of native SQL tables with have the password_last_updated containing the current date of restore.

      MySQL-5.7/8.0 has this value in the mysql.user table as password_last_changed column.
      MySQL doesn't expose a native SQL mechanism for setting this either.

      Postgres has a "VALID UNTIL timestamp" in their CREATE USER/CREATE ROLE

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.