Mysql时区错误问题，The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one...

在执行sql的时候会报错 The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one

数据库连接配置

 

将配置改为如下就解决mysql时区错误的问题

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=GMT%2B8
jdbc.username=root
jdbc.password=root

转载于:https://my.oschina.net/wwyxhqc/blog/2980193