spring与mysql8_spring boot连接mysql8.0

今天spring boot的项目数据库从mysql5.7换到mysql8.0，遇到点问题，特此记录下来

查看mysql的版本

mysql> select version();

+-----------+

| version() |

+-----------+

| 8.0.12 |

+-----------+

修改mysql的依赖使用MySQL Connector/J

mysql

mysql-connector-java

8.0.12

数据源配置

# 数据源配置，请修改为实际配置

spring.datasource.url=jdbc:mysql://localhost:3306/bim?serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useSSL=false&failOverReadOnly=false

spring.datasource.username=bimengine

spring.datasource.password=fgBQLZpgDaxH7xuu

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

项目启动报错

java.sql.SQLException: The connection property ‘zeroDateTimeBehavior‘ acceptable values are: ‘CONVERT_TO_NULL‘, ‘EXCEPTION‘ or ‘RO