You must configure either the server or JDBC driver (via the serverTimezone configuration property)

在SpringBoot项目中,在application.properties文件中配置Mysql数据源时出现以下问题:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  Cause: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.

原因是数据库和系统时区差异引起的

解决：

1.降低数据库版本(不推荐使用)
2.在url后面添加serverTimezone=UTC&characterEncoding=utf-8或
serverTimezone=GMT&characterEncoding=utf-8,如果指定使用gmt+8时区,需要写成GMT%2B8