解决报错:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone.

最近在编译java程序时报错如下:

问题:

java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

解决方案为:

在jdbc链接参数设置 serverTimezone=UTC 设置时区

jdbc:mysql://localhost:3306/test?serverTimezone=UTC

posted on 2021-07-29 06:34  keinlou  阅读(106)  评论(0编辑  收藏  举报