5.7新功能
直接使用户过期:
alter user loge@'%' password expire;
账号可以正常登录,但是所有查询功能不能进行
[root@centos ~]# mysql -uloge -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 732616
Server version: 5.7.9
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use db2
ERROR 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 selected
mysql> 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 names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> 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;