title: Resetting ROOT password in MySQL 5.6
body: <p>I have been following <a href="http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html">these instructions</a> for resetting <strong>root</strong> password for local installation of <code>MySQL 5.6</code> on Windows 7 laptop.</p>
  
  <p>I stopped the service, created <em>init-file</em>, and ran the following command (as Administrator):</p>
  
  <pre><code>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --init-file=C:\\MySQL-misc\\mysql-init.txt
  </code></pre>
  
  <p>I got the following <strong>warning</strong>:</p>
  
  <blockquote>
    <p>2014-02-08 15:44:10 0 [Warning] TIMESTAMP with implicit DEFAULT value
    is deprecated. Please use --explicit_defaults_for_timestamp server
    option (see documentation for more details).</p>
  </blockquote>
  
  <p>Since it's a warning I'm not sure whether I need to fix anything and then redo the process again.</p>
  
  <p>Currently the command window is still on and does not accept any input. Should I force-close it or is there anything I can do to complete the process gracefully?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I killed the Command window and tried to restart the service.  Got an error.  </p>
  
  <p>Restarted Windows and the service automatically started. The <strong>new</strong> <code>root password</code> seems to work.  I was successfully able to use various functions of Workbench that require the password.</p>
  
  <p>So, the warning was indeed just a warning.</p>