How to enable explicit defaults for timestamp

Question

When I try to start my mySQL server I get message       Warning  TIMESTAMP with implicit DEFAULT value is deprecated    Please use --explicit defaults for timestamp server option  see   documentation for more details     I find answer on  http   dev mysql com doc refman 5 6 en server-system-variables html sysvar explicit defaults for timestamp  But how to enable it  Where

User · Answer

I m Using Windows 8 1 and I use this command  c  wamp bin mysql mysql5 6 12 bin mysql exe   instead of   c  wamp bin mysql mysql5 6 12 bin mysqld   and it works fine

User · Answer

On Windows you can run server with option key  no need to change ini files    C  mysql bin mysqld exe  --explicit defaults for timestamp 1

User · Answer

In your mysql command line  SET explicit defaults for timestamp 1

User · Answer

On Windows -- open my ini file  present at  C  ProgramData MySQL MySQL Server 5 6    find   mysqld    without quotes  in next line add explicit defaults for timestamp and then save the changes

User · Answer

In your mysql command line do the following   mysql gt  SHOW GLOBAL VARIABLES LIKE   timestamp     --------------------------------- -------    Variable name                     Value    --------------------------------- -------    explicit defaults for timestamp   OFF       log timestamps                    UTC      --------------------------------- -------  2 rows in set  0 01 sec   mysql gt  SET GLOBAL explicit defaults for timestamp   1  Query OK  0 rows affected  0 00 sec   mysql gt  SHOW GLOBAL VARIABLES LIKE   timestamp     --------------------------------- -------    Variable name                     Value    --------------------------------- -------    explicit defaults for timestamp   ON        log timestamps                    UTC      --------------------------------- -------  2 rows in set  0 00 sec

User · Answer

For me it worked to add the phrase  explicit defaults for timestamp   ON  without quotes into the config file my ini    Make sure you add this phrase right underneath the  mysqld  statement in the config file    You will find my ini under C  ProgramData MySQL MySQL Server 5 7 if you had conducted the default installation of MySQL

User · Answer

First you don t need to change anything yet      Those nonstandard behaviors remain the default for TIMESTAMP but as of   MySQL 5 6 6 are deprecated and this warning appears at startup   Now if you want to move to new behaviors you have to add this line in your my cnf in the  mysqld  section   explicit defaults for timestamp   1   The location of my cnf  or other config files  vary from one system to another  If you can t find it refer to https   dev mysql com doc refman 5 7 en option-files html

User · Answer

On my system  Windows 8 1   the problem was with the server configuration  The server worked for the first time when I installed it  However  I forgot to check the  run as a service  option and this caused all the problem  I tried all possible solutions available on SO but nothing worked  So  I decided to reinstall MySQL Workbench  On executing the same msi file that I earlier used to install MySQL workbench  I reconfigured the server and allowed to run the server as a service

User · Answer

On a Windows platform   Find your my ini configuration file  In my ini go to the  mysqld  section  Add explicit defaults for timestamp true without quotes and save the change  Start mysqld  This worked for me  windows 7 Ultimate 32bit

[mysql] How to enable explicit_defaults_for_timestamp?

Examples related to mysql