summaryrefslogtreecommitdiff
path: root/mysql-test/main/system_mysql_db_507.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-7597 Expiration of user passwordsRobert Bindar2019-02-211-0/+33
| | | | | | | | | | | | | | | | | 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
* MDEV-13095 Implement User Account lockingRobert Bindar2019-02-141-0/+21
| | | | | | | | | | | | | | Add server support for user account locking. This patch extends the ALTER/CREATE USER statements for denying a user's subsequent login attempts: ALTER USER user [, user2] ACCOUNT [LOCK | UNLOCK] CREATE USER user [, user2] ACCOUNT [LOCK | UNLOCK] The SHOW CREATE USER statement was updated to display the locking state of an user. Closes #1006
* MDEV-17658 change the structure of mysql.user tableSergei Golubchik2018-12-121-5/+0
| | | | | | Implement User_table_json. Fix scripts to use mysql.global_priv. Fix tests.
* extend the test case to better emulate 5.7 user tableSergei Golubchik2018-12-121-0/+174