title: mysql root password forgotten
body: <p>I did not use PHP MySQL for quite a while and now I need to use it again. But the problem is I forget the password for the MySQL console. and getting error #1045 when trying to login in to PHPMyAdmin.</p>
  <p>In the MySQL site I saw an article how to reset root password( <a href="http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows</a>)</p>
  <p>Steps are</p>
  <pre><code>create a mysql-init.txt file containing UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='root';
  FLUSH PRIVILEGES;
  </code></pre>
  <p>I saved it as <code>C:\me\mysql-init</code></p>
  <p>and in command prompt I wrote--</p>
  <pre><code>C:\wamp\bin\mysql\mysql5.5.8\bin\mysqld --init-file=C:\me\mysql-init.txt 
  </code></pre>
  <p>I tried with double backslashes also..but it is not working. MySQL console is asking for a password and it's not taking the new-one. What am I doing wrong? I have several tables there.what to do?</p>
  <p>Thanks in advance.</p>