CODEWITHSUNDEEP
windowstimestampmysql
Andrew
Andrew

Reputation: 3989

Timestamp error when attempting to run mysqld

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.

Upvotes: 0

Views: 5269

Answers (4)

Saifur
Saifur

Reputation: 16201

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

Upvotes: 0

jas jashim
jas jashim

Reputation: 196

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.

Upvotes: 1

Arun Raja
Arun Raja

Reputation: 1674

Even I faced the same issue Try passing

explicit_defaults_for_timestamp = 1

Upvotes: 1

5AR
5AR

Reputation: 11

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?

Upvotes: 0

Related Questions