异常
1. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Caused by: java.sql.SQLException: Access denied for user 'root'@'test17' (using password: YES)
在创建新的连接的时候,连接不上mysql
分析
-
项目中使用Druid作为连接池,使用druid的密码进行加密
com.alibaba.druid.filter.config.ConfigTools.main(new String[]{ "xxxxxx"}); //返回加密后的公钥和私钥
-
配置信息
spring: datasource: druid: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/tj_bidding?useUnicode=true&useSSL=false&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=Asia/Shanghai&autoReconnect=true&failOverReadOnly=false username: root password: <加密后的密钥> ## config这个fliter必须配置用于密码解密 filters: config,stat,wall,slf4j connection-properties