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)
即可!