Status: Open (View Workflow)
If a user suddenly will be locked (even in sandbox mode) ,
it can have an impact on some systems,
epecially if also running some daily scripts with the same user.
So a grace period can be added.
during grace period a warning should be thrown with every execution of a query and during login.
WARNING xxxx (xxxxx): Password expire in x days. Please set a new password.
Add new variable:
Add new keyword for creatiing user:
optional keyword CREATE USER
CREATE USER 'user'@'%' identified by 'Secretpass2!' PASSWORD EXPIRE INTERVAL 10 DAY GRACE_PERIOD 1 DAY;
- relates to
MDEV-7597 Expiration of user passwords