Archive
This post is archived and may contain outdated information. It has been set to 'noindex' and should stop showing up in search results.
This post is archived and may contain outdated information. It has been set to 'noindex' and should stop showing up in search results.
MySQL Timestamp with Implicit Default Value Depreciated Startup on Windows
Jan 14, 2015Web DevelopmentComments (1)
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 = 1If 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".