MySQL Build report TIMESTAMPN error:invalid default value for ' timestamp '

Environment: MySQL 5.7.16

System: CentOS 6.8 64

Baidu query to, because is the version of the problem caused.

Solution:

1. Open the/ETC/MY.CNF configuration file

Add the following at the end:

explicit_defaults_for_timestamp = True

Sql_mode=strict_trans_tables,error_for_division_by_zero,no_auto_create_user,no_engine_substitution

Save, restart MySQL, test OK.

This article from "Hisus" blog, declined reprint!

MySQL Build report TIMESTAMPN error:invalid default value for ' timestamp '