MySQL提示密码过期

解决MySQL密码过期问题

最新推荐文章于 2024-06-11 09:37:32 发布

原创最新推荐文章于 2024-06-11 09:37:32 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #java #密码

java 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了当使用Java连接MySQL时遇到密码过期错误的两种解决方法。首先可以通过设置新密码来更新当前用户的密码状态，其次可以更新MySQL的user表以修改所有受影响用户的密码过期状态。

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)

即可！