springboot中mysql连接配置

2021-07-17 06:04:40

1.properties格式

# 数据库配置mysql5
  spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  spring.datasource.username=
  spring.datasource.password=
  spring.datasource.url=jdbc:mysql://localhost:3306/dbName?useSSL=false&useUnicode=true&characterEncoding=utf-8

2.yml格式

# 数据库配置mysql8
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/za?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
    username: 
    password:

3.其他

properties与yml在线互转