Mysql5.7の起動はプロンプトです[警告]暗黙のDEFAULT値を持つTIMESTAMPは非推奨です



Mysql 5 7 Startup Is Prompt Timestamp With Implicit Default Value Is Deprecated



os:ubuntu 16.04
db:mysql 5.7.25

2019-03-06T03:27:26.404335Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). mysql> show global variables like '%timestamp%' +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | explicit_defaults_for_timestamp | OFF | | log_timestamps | UTC | +---------------------------------+-------+ 2 rows in set (0.00 sec)

ドキュメントを表示した後、これをに設定すると言います



# vi /etc/mysql/mysql.conf.d/mysqld.cnf explicit_defaults_for_timestamp=1

mysqlを再起動してもエラーは表示されません

参照:
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp