Support password expiry, last changed, lifetime attributes

[morgo]

Feature Request

Is your feature request related to a problem? Please describe:

In MySQL 5.7 the user table has attributes for password_expired, password_last_changed, password_lifetime. These are helpful for user management.

Describe the feature you'd like:

• It should be possible to set a password as expired.
• It should be possible to see the date a password was last changed.
• It should be possible to force a password to be changed every n days.

Describe alternatives you've considered:

N/A

Teachability, Documentation, Adoption, Migration Strategy:

These are features of MySQL 5.7.

[zz-jason]

To fully support these attributes, seems we need to support the Password Expiration Policy in MySQL.

[dveeden]

The user attributes introduced in MySQL 8.0 should also be considered as part of this if possible.

[dveeden]

@CbcWestwolf What's missing here? Maybe add a list to the description?

[CbcWestwolf]

@dveeden I think we can close this issue now :-)
The feature has been implemented in the mentioned PR.