mybug

问题：

这是在使用MySQL 8.0以上版本（MySQL连接驱动和版本都是8.0以上）的时候出现的问题错误

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.

我们需要在访问数据库的Url后面加上以下的语句即可：  serverTimezone=GMT%2B8

原因：数据库的日期时间字段的值为：0000-00-00 00:00:00 

com.mysql.cj.exceptions.DataReadException: Zero date value prohibited

 解决：zeroDateTimeBehavior=convertToNull

 在application.yml的完整示例

spring:
  datasource:
    url: jdbc:mysql:///mydb1?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
    username: root
    password: 1234
    driver-class-name: com.mysql.cj.jdbc.Driver