MySQL Timestamp with Implicit Default Value Depreciated Startup on Windows

Jan 14, 2015   Web Development   Nick Vogt   Comments (1)
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:

[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".
Share This Post

Comments (1)

Saifur Rahman   Apr 19, 2015
Should be --explicit_defaults_for_timestamp = 1
Share This Post
H3XED © Nick Vogt   RSS   Policies   Twitter