title: I can't start Mysql 5.6 server due to "TIMESTAMP with implicit DEFAULT value is deprecated" Error?
body: <p>Ok, Here is my story, I went to mysql.com site &amp; downloaded the file <code>mysql-5.6.11-winx64.zip</code> into C:, then I unziped it. Then I went to bin folder &amp; started the server by using this command:</p>
  
  <pre><code>C:\mysql-5.6.11-winx64\bin\mysqld --standalone --local-infile=1
  </code></pre>
  
  <p>Everything was ok as the Mysql server started smoothly. I then stopped server using this command:</p>
  
  <pre><code>C:\mysql-5.6.11-winx64\bin\mysqladmin -u root shutdown
  </code></pre>
  
  <p>The Server was shutdowned properly.</p>
  
  <p>I used this way to start &amp; stop mysql server a few times without any problem. </p>
  
  <p>However, yesterday, I started the Mysql server but then, at the end of the day, i turned off my PC while my MySQL server was still in the Starting Mode (ie, i did not shutdown mysql using "<code>bin\mysqladmin -u root shutdown</code>" before turned off my PC). </p>
  
  <p>Also, when my PC got turned off at that time, the Win 7 was starting to download some packages from the internet to update Win7 so the configuration of win7 could be changed.</p>
  
  <p>But today I could not start Mysql Server using the above command as there's an error:</p>
  
  <pre>
  [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. 
  Pls use --explicit_defaults_for_timestamp server option (see documentation for more details).
  </pre>
  
  <p>I searched over internet &amp; some people said that I have to go to my.cnf file &amp; add this line into:</p>
  
  <pre><code>explicit_defaults_for_timestamp = TRUE
  </code></pre>
  
  <p>However, there is no my.cnf file in mysql 5.6, there a lot of cnf file in mysql5.6 but with different names:</p>
  
  <pre><code>mysql-5.6.11-winx64\data\auto.cnf
  mysql-5.6.11-winx64\mysql-test\include\default_client.cnf
  mysql-5.6.11-winx64\mysql-test\include\default_my.cnf
  mysql-5.6.11-winx64\mysql-test\include\default_mysqld.cnf
  mysql-5.6.11-winx64\mysql-test\include\default_mysqld_autosize.cnf
  mysql-5.6.11-winx64\mysql-test\include\default_mysqld_ndbd.cnf
  </code></pre>
  
  <p>I tried to add <code>explicit_defaults_for_timestamp = TRUE</code> into all above cnf file but no help, i still couln't start mysql</p>
  
  <p>I don't want to reinstall cos I created a big DB in the current mysql Server.</p>
  
  <p>So how to fix it?</p>
  
  <p><b>Note</b>: when first time I ran Mysql server, win7 pop up a message saying something (i couldn't remember) such as "do you allow ... Firewall", so do u think that is causing the issue since Win7 got its configuration updated &amp; somehow it reset the Firewall so the Mysql server couldn't start? </p>