The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more than one time zone.

    科技2024-01-29  90

    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.

    出现异常原因:

    使用mysql的jdbc驱动最新版(6.0+)时,会遇到数据库和系统时区差异引起的问题。

    解决方案:

    在配置文件(application.yml)中的,配置数据库时在jdbc的url后面加上一条serverTimezone=CST CST代表的是中国上海时间(与北京时间,东八区相同)。

    Processed: 0.009, SQL: 8