mysql 密码过期
查询SQL：select user,host, password_expired,password_lifetime,account_locked from mysql.user;
+---------------+--------------+------------------+-------------------+----------------+
| user | host | password_expired | password_lifetime | account_locked |
+---------------+--------------+------------------+-------------------+----------------+
| root | % | N | 0 | N |
| mysql.session | localhost | N | NULL | Y |
| mysql.sys | localhost | N | NULL | Y |
| Tuneuser | % | N | 0 | N |
| fcuser | % | N | 0 | N |
| dbbak | % | N | 0 | N |
| manager | % | N | 0 | N |
| sapuser | % | N | 0 | N |
| fw | % | N | 0 | N |
| Wbj | % | N | 0 | N |
| xtrabak | % | N | 0 | N |
| root | 172.16.7.210 | N | 0 | N |
| dbbak | localhost | N | 0 | N |
| wangwl | % | N | 0 | N |
| NCCSelect | % | N | 0 | N |
| zabbix | % | N | 0 | N |
| nacos | % | N | 0 | N |
| wangjinghong | % | N | 0 | N |
+---------------+--------------+------------------+-------------------+----------------+
18 rows in set (0.00 sec)
修改账号为密码永不过期：
alter user 'Wbj'@'%' password expire never;
mysql 参数文件：my.cnf 需重启mysql
default_password_lifetime=0 #如果设置为零标识永不过期
