MySQL5.7升级到MySQL8.0.11需要注意的问题

1.错误类型

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

2.图片

MySQL5.7升级到MySQL8.0.11需要注意的问题 3.错误原因

MySQL升级之后驱动发生了改变所以要改变驱动具体操作如下

<1>pom.xml文件中MySQL版本改变

<mysql-connector-java.version>8.0.11</mysql-connector-java.version>

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

<2>yml文件中的DataSource文件配置改变

  ###################  数据库配置  ###################
  datasource:
    db-name: test
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
    username: root
    password: root
    filters: log4j,wall,mergeStat

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

useSSL=false

serverTimezone=GMT%2B8

2.未升级的版本

###################  数据库配置  ###################
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
    driver-class-name: com.mysql.jdbc.Driver
    username: test
    password: test
    db-name: test
    filters: log4j,wall,mergeStat

MySQL5.7升级到MySQL8.0.11需要注意的问题

相关推荐