MySQL提示密码过期

java连接mysql（5.6），提示如下

Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Your password has expired. To log in you must change it using a client that supports expired passwords.

方法一：

SET PASSWORD = PASSWORD('123456');

这个命令只修改当前用户，修改下面3个需要用-h来指定即可。下表中‘N’表示过期

mysql> use mysql

mysql> select host,user,password_expired from user;
+-------------------------+------+------------------+
| host                    | user | password_expired |
+-------------------------+------+------------------+
| %                       | root | N                |
| c6509.ambari.apache.org | root | Y                |
| 127.0.0.1               | root | Y                |
| ::1                     | root | Y                |
+-------------------------+------+------------------+

方法二

update user set password_expired = 'N';

在查看

mysql> select host,user,password_expired from user;
+-------------------------+------+------------------+
| host                    | user | password_expired |
+-------------------------+------+------------------+
| %                       | root | N                |
| c6509.ambari.apache.org | root | N                |
| 127.0.0.1               | root | N                |
| ::1                     | root | N                |
+-------------------------+------+------------------+
4 rows in set (0.00 sec)

即可！