mysql版本报错
IntelliJIdea2019.3打开原项目报mysql版本报错:
Error opening zip file or JAR manifest missing : /C:/Users/flycat/.IntelliJIdea2019.3/config/plugins/mysql-explain/lib/mysql-explain-agent-jar-with-dependencies.jar
查看MYSQL版本,原来是5.1.40,直接调整为8.0.19解决方法:<mysql.version>8.0.19</mysql.version>
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> <scope>runtime</scope></dependency>依然报错,进一步分析,MYSQL8的连接串是com.mysql.cj.jdbc.Driver,V5的是com.mysql.jdbc.Driver且需要在URL中加入&useSSL=false&&serverTimezone=CST
数据库连接配置也要做相应的调整:
type: com.alibaba.druid.pool.DruidDataSourceurl: jdbc:mysql://localhost:3306/smartfactory?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&&serverTimezone=CSTusername: rootpassword: connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000;password=${spring.datasource.password}driverClassName: com.mysql.cj.jdbc.Driver
相关推荐
Andrea0 2020-09-18
emmm00 2020-11-17
王艺强 2020-11-17
aydh 2020-11-12
世樹 2020-11-11
zry 2020-11-11
URML 2020-11-11
spurity 2020-11-10
yifangs 2020-10-13
Ida 2020-09-16
ltd00 2020-09-12
tufeiax 2020-09-03
xjd0 2020-09-10
greatboylc 2020-09-10
adsadadaddadasda 2020-09-08
疯狂老司机 2020-09-08
CoderToy 2020-11-16
ribavnu 2020-11-16
bianruifeng 2020-11-16