From 90ad4dbd17a44c64cfaf8cb81588d3f999efd40b Mon Sep 17 00:00:00 2001 From: Robert Bindar Date: Wed, 16 Jan 2019 19:44:30 +0200 Subject: MDEV-7597 Expiration of user passwords This patch adds support for expiring user passwords. The following statements are extended: CREATE USER user@localhost PASSWORD EXPIRE [option] ALTER USER user@localhost PASSWORD EXPIRE [option] If no option is specified, the password is expired with immediate effect. If option is DEFAULT, global policy applies according to the default_password_lifetime system var (if 0, password never expires, if N, password expires every N days). If option is NEVER, the password never expires and if option is INTERVAL N DAY, the password expires every N days. The feature also supports the disconnect_on_expired_password system var and the --connect-expired-password client option. Closes #1166 --- mysql-test/suite/plugins/t/multiauth.test | 1 + 1 file changed, 1 insertion(+) (limited to 'mysql-test/suite/plugins/t/multiauth.test') diff --git a/mysql-test/suite/plugins/t/multiauth.test b/mysql-test/suite/plugins/t/multiauth.test index 166ae30d3c7..46af3f1388b 100644 --- a/mysql-test/suite/plugins/t/multiauth.test +++ b/mysql-test/suite/plugins/t/multiauth.test @@ -130,6 +130,7 @@ drop user mysqltest1; # create user mysqltest1 identified via ed25519 as password("good") OR unix_socket OR mysql_native_password as password("works"); show grants for mysqltest1; +--replace_regex /password_last_changed": [0-9]*/password_last_changed": 0/ select json_detailed(priv) from mysql.global_priv where user='mysqltest1'; select password,plugin,authentication_string from mysql.user where user='mysqltest1'; flush privileges; -- cgit v1.2.1