Mysql 5.7 账户过期设置

5.7新功能

直接使用户过期：

alter user loge@'%' password expire;

账号可以正常登录，但是所有查询功能不能进行

[root@centos ~]# mysql -uloge -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 732616Server version: 5.7.9Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use db2ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> select * from t_t123;ERROR 1046 (3D000): No database selectedmysql> alter user loge@'%' identified by 'Usa123!';Query OK, 0 rows affected (0.00 sec)mysql> use db2;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select * from t_t123;+------+| id   |+------+|    1 |+------+1 row in set (0.00 sec)

其他操作

修改配置文件默认过期天数：

[mysqld]default_password_lifetime=180 #如果设置为零标识永不过期

动态修改,服务重启之后设置无效：

SET GLOBAL default_password_lifetime = 180;SET GLOBAL default_password_lifetime = 0

创建变更用户时候：

create user loge@'%' identified by '123456' password expire interval 90 day;alter user loge@'%' identified by '123456' password expire interval 90 day;# 禁用过期，永久不过期：create user loge@'%' identified by '123456' password expire never;alter user loge@'%' identified by '123456' password expire never;