Mysql高低版本切换需要修改的配置58（此处以aicode为例）(WARN:EstablishingSSLconnectionwithoutserver‘sidentityveri)

我这边出现此种报错的原因是我本地的数据在后面升级为了8.0版本的数据库&＃xff0c;然后代码得到配置依照5.7的版本进行配置&＃xff0c;因为升级数据库导致很多代码都出现了问题&＃xff0c;故做此记录&＃xff1b;希望可以帮助到大家

当我们跟换数据库后&＃xff0c;初次启动数据库版本高低冲突导致的报错&＃xff1a;

WARN: Establishing SSL connection without server&＃39;s identity verification is not recommended. According to MySQL 5.5.45&＃43;, 5.6.26&＃43; and 5.7.6&＃43; requirements SSL connection must be established by default if explicit option isn&＃39;t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to &＃39;false&＃39;. You need either to explicitly disable SSL by setting useSSL&＃61;false, or set useSSL&＃61;true and provide truststore for server certificate verification.


我本地环境是8.0的MYsql 数据库故配置修改为 8.0

<mysql-connector-java.version>8.0.21</mysql-connector-java.version><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql-connector-java.version}</version></dependency>


或者

<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.21</version></dependency>


修改完之后
再次启动报错&＃xff1a;

Loading class com.mysql.jdbc.Driver&＃39;. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

把com.mysql.jdbc.Driver修改com.mysql.cj.jdbc.Driver

我们做如下修改
加入这个

driver-class-name: com.mysql.cj.jdbc.Driver


Could not create connection to database server. Attempted reconnect 3 times. Giving up.


1、将所有的driver-class-name值都从com.mysql.jdbc.Driver修改为com.mysql.cj.jdbc.Driver&＃xff08;上面说过了&＃xff09;

2、在url的参数后面新增时区参数&＃xff1a;&serverTimezone&＃61;UTC

3、修改url连接参数中的值更新为&＃xff1a;zeroDateTimeBehavior&＃61;CONVERT_TO_NULL

spring:profiles: devdatasource:#url: jdbc:mysql://localhost:3306/easycode?autoReconnect&＃61;true&useUnicode&＃61;true&characterEncoding&＃61;utf8&zeroDateTimeBehavior&＃61;convertToNullurl: jdbc:mysql://localhost:3306/easycode?autoReconnect&＃61;true&useUnicode&＃61;true&characterEncoding&＃61;utf8&zeroDateTimeBehavior&＃61;CONVERT_TO_NULL&serverTimezone&＃61;UTCusername: rootpassword: rootfilters: log4j,wall,mergeStatdriver-class-name: com.mysql.cj.jdbc.Driver


注释了的是以前的&＃xff1b;新的是修改后的&＃xff1b;

希望可以帮助到大家&＃xff1b;