SpringBoot配置mysql5和mysql8的数据源

mysql 8

必须加时区serverTimezone,不然启动回报错

注意yml文件的分层书写

datasource:

type: com.alibaba.druid.pool.DruidDataSource

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

url: jdbc:mysql://localhost:3306/dbName?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8

username: root

password: root

mysql 5 及以前

datasource:

type: com.alibaba.druid.pool.DruidDataSource

driver-class-name: org.gjt.mm.mysql.Driver

#driverClassName: com.mysql.jdbc.Driver

url: jdbc:mysql://localhost:3306/dbName?useUnicode=true&characterEncoding=UTF-8&useSSL=false

username: root

password: root