解决Caused by: : The server time zone value

时间:2025-02-06 20:01:31

Caused by: : 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 configurat

此问题为时区问题,在 JDBC 的连接 url 部分加上 serverTimezone=UTC 即可。
如果选择utc会比中国时间早8个小时,如果在中国,可以选择Asia/Shanghai或者Asia/Hongkong

    url: jdbc:mysql://localhost:3306/mydb01?serverTimezone=UTC