mysql 8.0设置日期为0000-00-00 00:00:00时报错

编辑mysql配置文件my.ini,删除 NO_ZERO_IN_DATE,NO_ZERO_DATE

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

删除后重新启动mysql,再试成功。

mysql 8.0设置日期为0000-00-00 00:00:00时报错

上一篇:(新)Linux 安装、配置 MondoDB


下一篇:连接JDBC报错:com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.