set explicit_defaults_for_timestamp to avoid warning

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

the value set should be the previous behaviour except no warning in logs

diff --git a/mysqld.conf b/mysqld.conf
index b1351a06037e7e4dec395275e090dde4986287c9..9a576f25d38a898089e344abc2fc0976b86d22b2 100644 (file)
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -184,6 +184,9 @@ slow-query-log-file = /var/log/mysql/slow.log
 #query_cache_size=8M
 #query_cache_limit=1M
 
+# https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
+explicit_defaults_for_timestamp=false
+
 # Fulltext search options
 #ft_min_word_len=2