[MySQL] TIMESTAMP with implicit DEFAULT value is deprecated

Posted on November 17, 2016 at 7:15 pm

If mysql service can’t start due to this warning:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

You just need to edit your my.cnf file and add:

explicit_defaults_for_timestamp = 1

Under the [mysqld] section.

Then restart mysql:

/etc/init.d/mysql restart

Stay Updated

Other Posts

Updated Posts