大家好!
在centos上成功部署了多次tomcat后,昨天意外出现了,启动tomcat,报以下错误:
ava.sql.SQLException: Your password has expired. To log in you must change it using a client that supports expired
passwords.所以觉得有必要和大家说下!
运行环境:
mysql:5.6.24
tomcat:apache-tomcat-7.0.54-windows-x64
java:1.8
数据库连接池:tomcat.jdbc
问题现象:
1、启动tomcat,就会报以上错误
2、navicat工具可以正常连接
解决方案:
1、select * from mysq.user 可查password_expired 都是y(注意:下面截图是我修改以后的截图)
2、将password_expired 修改为N
3、update user set password_expired="N" where password_expired="Y";
4、重启数据库,重启tomcat,问题解决!