[MDEV-24103] mysqldump --system=users password_last_changed not saves MariaDB-10.4+, MySQL-5.7+ Created: 2020-11-03  Updated: 2020-11-03

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4.16
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24102 GRANT USAGE ON *.* TO USER IDENTIFIED... Open

 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


Generated at Thu Feb 08 09:27:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.