mysql连接报错:The server time zone value '�й���׼ʱ��'

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.


解决方法:
在连接字符串后面加上时区设置:?serverTimezone=UTC,其中UTC是统一标准世界时间。
示例:
url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC

posted @ 2024-01-27 23:50  kiss_sheep  阅读(430)  评论(0)    收藏  举报