Timestamp error when attempting to run mysqld

Question

When I attempt to run mysqld through the Command Prompt to enter that, I get an error saying:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. 
Please use --explicit_defaults_for_timestamp server option (see documentation for
more details).

I've tried pasting explicit_defaults_for_timestamp = TRUE into the my.ini file, but that didn't work.

score 1 · Answer 1 · answered Nov 25 '14 at 04:27

1

Even I faced the same issue Try passing

explicit_defaults_for_timestamp = 1

answered Nov 25 '14 at 04:27

Arun Raja

1,554
16
26

score 1 · Answer 2 · answered Feb 18 '15 at 18:23

1

Try this Go to mysql server installation directory C:\program files\mysql\mysql server 5.6\ check for file my.ini if it is not there duplicate my-default.ini file any rename it to my.ini and add explicit_defaults_for_timestamp = 1 and save it.

answered Feb 18 '15 at 18:23

jas jashim

186
1
1
8

score 0 · Answer 3 · edited May 23 '17 at 12:06

0

You can read more here. http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp

but I guess you only need to run Command Prompt as Administrator

also look at this question How to enable explicit_defaults_for_timestamp?

edited May 23 '17 at 12:06

Community

1
1

answered Oct 04 '14 at 23:14

5AR

11
1

score 0 · Answer 4 · answered Apr 19 '15 at 16:49

0

Add the following command and should work. Make sure add --

d:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld.exe --init-file=D:\\mysql-ini
t.txt --explicit_defaults_for_timestamp = 1

answered Apr 19 '15 at 16:49

Saifur

16,081
6
49
73

Timestamp error when attempting to run mysqld

4 Answers4