MySQL密码过期问题处理（Your password has expired）

查看用户

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+

查看密码过期情况(Y:过期 N:未过期)

mysql> select user,host,password,password_expired from mysql.user where user = 'root';
+------+-----------+-------------------------------------------+------------------+
| user | host      | password                                  | password_expired |
+------+-----------+-------------------------------------------+------------------+
| root | localhost | *BF7B173F1C146F576CC267F0BAEF5589A08404FB | N                |
| root | cent002   | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | Y                |
| root | 127.0.0.1 | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | Y                |
| root | ::1       | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | Y                |
| root | %         | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | N                |
+------+-----------+-------------------------------------------+------------------+

修改指定用户过期密码

mysql> set password for 'root'@'cent002' = password('root123');

重新查看

mysql> select user,host,password,password_expired from mysql.user where user = 'root';
+------+-----------+-------------------------------------------+------------------+
| user | host      | password                                  | password_expired |
+------+-----------+-------------------------------------------+------------------+
| root | localhost | *BF7B173F1C146F576CC267F0BAEF5589A08404FB | N                |
| root | cent002   | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | N                |
| root | 127.0.0.1 | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | Y                |
| root | ::1       | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | Y                |
| root | %         | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 | N                |
+------+-----------+-------------------------------------------+------------------+