MySQL Timestamp with Implicit Default Value Depreciated Startup on Windows
Please note that this post is over a year old and may contain outdated information.
If you receive this warning when starting MySQL (mysqld.exe) on Windows:
One common solution is to add this line to your my.ini configuration file in the [mysqld] section:
If you don't have a my.ini configuration file in your MySQL root folder, but do have a my-default.ini file, then you need to create a my.ini configuration file by duplicating my-default.ini and renaming it to "my.ini".
Be sure to turn on Windows file extensions to make renaming files easier. You don't want to end up with "my.ini.ini".
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
One common solution is to add this line to your my.ini configuration file in the [mysqld] section:
explicit_defaults_for_timestamp = 1
If you don't have a my.ini configuration file in your MySQL root folder, but do have a my-default.ini file, then you need to create a my.ini configuration file by duplicating my-default.ini and renaming it to "my.ini".
Be sure to turn on Windows file extensions to make renaming files easier. You don't want to end up with "my.ini.ini".