bug宝典JAVA篇 Your password has expired

最新推荐文章于 2023-01-11 11:23:08 发布

warrah

最新推荐文章于 2023-01-11 11:23:08 发布

阅读量739

点赞数

CC 4.0 BY-SA版权

分类专栏：岁月云——测试文章标签： mysql bug

本文链接：https://blog.youkuaiyun.com/warrah/article/details/53456406

岁月云——测试专栏收录该内容

77 篇文章

订阅专栏

本文记录了在部署应用到Linux服务器过程中遇到的MySQL密码过期错误，并详细展示了错误信息及解决方案，包括检查配置文件、更新用户密码等步骤。

我将应用部署到linux服务器上，提示这样的错误。说是密码过期？怎么可能。

20:09:45.130 ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
java.sql.SQLException: Your password has expired. To log in you must change it using a client that supports expired passwords.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.40.jar:5.1.40]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) ~[mysql-connector-java-5.1.40.jar:5.1.40]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) ~[mysql-connector-java-5.1.40.jar:5.1.40]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) ~[mysql-connector-java-5.1.40.jar:5.1.40]

查看jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=cRsnF9Fcc+OoMrQony3QCMijaDW5+j6ZMlzPsIxRzzJJGqM6fuIXHGHvGqxGco3zUrqk2TjszYyeEdHIN14g==

#druid connection pool settings
druid.initialSize=10
druid.minIdle=10
druid.maxActive=50
druid.maxWait=60000
druid.timeBetweenEvictionRunsMillis=60000
druid.minEvictableIdleTimeMillis=300000
druid.validationQuery=SELECT 'x'
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false
druid.poolPreparedStatements=true
druid.maxPoolPreparedStatementPerConnectionSize=20
druid.filters=config
druid.connectionProperties=config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAImNJeNfVoFD8A79O76kye03OLxY13rKxeIZQXmF9pd80CW9rCmGVpGmGGYIQ3AAxob9lPbCwKbTZ6y5PX4lsCAwEAAQ==