[Warning] TIMESTAMP with implicit DEFAULT value is deprecated

启动mysql时,报如下警告信息:

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

修改方法:

在配置my.cnf中加入,然后启动mysql

[mysqld]
explicit_defaults_for_timestamp=true

explicit_defaults_for_timestamp参数说明可以参考上一篇文章:

http://www.cnblogs.com/abclife/p/5051861.html

原文地址:https://www.cnblogs.com/abclife/p/5051589.html