MySQL密码过期设置
(1) 检查密码参数
mysql> show variables like 'default_password_lifetime';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| default_password_lifetime | 0 |
+---------------------------+-------+
(2) 如果密码要设置过期,则或者不过期
[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;