MySQL5.7日期报错解决---MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘

一、报错提示

MySQL:[Err] 1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'CREATE_TIME' at row 1

二、解决方法

[root@lmzf_test ~]#  cat  /etc/my.cnf

...
[mysqld]
sql_mode=strict_trans_tables,no_zero_in_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution

三、重启MySQL数据库