两种常见驱动
com.mysql.jdbc.Driver 是 mysql-connector-java 5版本,
com.mysql.cj.jdbc.Driver 是 mysql-connector-java 6以上版本
常见错误
错误原因很简单
mysql-connector-java 6以上需要在配置文件中加入时区
Mysql5配置文件
#mysql数据库连接
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/ceshi?useUnicode=true&characterEncoding=utf8&useSSL=false
username: root
password: root
Mysql6以上配置文件
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/ceshi?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8
username: root
password: root