当前我使用的是mysql-connector-java:8.0.18
版本,MySQL6之后的版本都是要指定时区serverTimezone的:
spring:
datasource:
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://192.168.0.100:3306/easyexcel?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
username: root
password: 123456
validationQuery: select 1
如需了解MySQL5和6驱动及配置的区别可以参考以下大佬的文章:
https://blog.csdn.net/superdangbo/article/details/78732700