mysql 8.0 数据库连接,数据源配置
MySQL依赖
依赖版本要对应自己数据安装版本
使用SQL查询select version() from dual;
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
</dependency>
datasource配置项
spring:
application:
name: cloud-payment-service
datasource:
type: com.alibaba.druid.pool.DruidDataSource # 当前数据源操作类型
driver-class-name: com.mysql.cj.jdbc.Driver # mysql驱动包
url: jdbc:mysql://localhost:3306/study?useSSL=false&serverTimezone=UTC
username: root
password: 123456
中间要加 cj
driver-class-name: com.mysql.cj.jdbc.Driver
后面要加上时区&serverTimezone=UTC
url: jdbc:mysql://localhost:3306/study?useSSL=false&serverTimezone=UTC