"[Warning] TIMESTAMP with implicit DEFAULT value" on install

[Robie Basak]

When installing mysql-server-5.6, the user gets the following warning printed to the terminal:

2014-05-14 13:54:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

This should not happen.

[Lars Tangvald (lars-tangvald)]

The cause is that MySQL used to only support implicit timestamp default value, which is not according to the SQL spec. When this was fixed, it was decided to keep the old behavior for historical reasons, but add a deprecation warning.

Adding the suggested value to the config would remove the warning, but we'd be changing the default behavior of the server.

[Robie Basak (racb)]

We can't fix this in 5.6 because it would change default behaviour, but we can fix it in 5.7. So leaving this open so we remember to do it.

[Angel Guzman Maeso (shakaran)]

Some progress for fix this at least in mysql 5.7 for Ubuntu 16.04?

[Joshua Powers (powersj)]

This still prints out for 5.7 on 16.04 (5.7.15-0ubuntu2)