mysql8_jdbc

已解决的问题

6月13日：

一、数据库驱动问题。

• 成功将MySQL8数据库驱动加入Springboot 3.1.0；

1. 查看MySQL数据库版本

(base) ➜  ~ brew list mysql

/usr/local/Cellar/mysql/8.0.33_1/.bottle/etc/my.cnf
/usr/local/Cellar/mysql/8.0.33_1/bin/comp_err
/usr/local/Cellar/mysql/8.0.33_1/bin/ibd2sdi
/usr/local/Cellar/mysql/8.0.33_1/bin/innochecksum
/usr/local/Cellar/mysql/8.0.33_1/bin/my_print_defaults
/usr/local/Cellar/mysql/8.0.33_1/bin/myisam_ftdump
/usr/local/Cellar/mysql/8.0.33_1/bin/myisamchk
/usr/local/Cellar/mysql/8.0.33_1/bin/myisamlog
/usr/local/Cellar/mysql/8.0.33_1/bin/myisampack
/usr/local/Cellar/mysql/8.0.33_1/bin/mysql

2. 引入依赖

   <!-- https://mvnrepository.com/artifact/com.mysql/mysql-connector-j -->
   <dependency>
       <groupId>com.mysql</groupId>
       <artifactId>mysql-connector-j</artifactId>
       <version>8.0.33</version>
   </dependency>
   

   注意版本要对应，不然可能会出现未知bug。

3. 配置application.yml文件

   spring:
     datasource:
       driver-class-name: com.mysql.cj.jdbc.Driver
       url: jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
       username: root
       password: password
       type: com.zaxxer.hikari.HikariDataSource
       hikari:
         maximum-pool-size: 15
         minimum-idle: 5