当前我使用的是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

Logo

更多推荐