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

  Linux下安装MySQL执行scripts/mysql_install_db --user=mysql脚本时,报错如下:

Filling help tables...2019-12-24 16:46:55 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

  解决办法:

  在my.cnf配置文件添加:

explicit_defaults_for_timestamp=true

  执行结果:

 

   保存退出即可。

原文地址:https://www.cnblogs.com/JohanChan/p/12092395.html