How to enable explicit_defaults_for_timestamp?

Sep 10, 2015 code

After upgrading my xampp with mysql to 5.6 I started getting an error when creating a new database. I looked everywhere for the answer. They kept saying put explicit_defaults_for_timestamp=1 but it wasn’t working. Turns out you have to put it in the right spot!

Open your my.ini file, present at “C:\xampp\mysql\bin”, find “[mysqld]” (without quotes) in next line add explicit_defaults_for_timestamp=1 and then save the changes.