MySQL密码过期设置

MySQL密码过期设置

(1) 检查密码参数

mysql> show variables like 'default_password_lifetime';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| default_password_lifetime | 0     |
+---------------------------+-------+

(2) 如果密码要设置过期，则或者不过期

• # my.cnf参数

[mysqld]
default_password_lifetim=0 或 360

(3) 永久：alter user

alter user 'username'@'localhost' password expire interval 90 day;

(4) 查询用户密码是否过期()

select user,password_lifetime from mysql.user where user='username';

(5) 设置不过期

alter user 'username'@'localhost' password expire never;

alter user 'username'@'localhost' password expire default;