title: MYSQL can't start service on Windows 7
body: <p>EDIT: This happened most of the times, due to power failure.  </p>
  
  <p>Two things which worked for me.<br>
  1. Knowing how to change root password in MySQL, and taking backup of databases.<br>
  2. Install MYSQL as service.
   <code>C:\&gt; "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --install</code></p>
  
  <p>I had done clean installation of MYSQL 5.6 few days ago.
  On first day everythng was fine. I could access city and world tables. </p>
  
  <p>On next day I started getting below errors. Some were I read to run mysqld at admin level.
  And it solved problem, but I couldn't access city and world table anymore.</p>
  
  <p>On third day. I am getting only this errors.</p>
  
  <p>Note: MYSQL service running previously fine, when firewall, antivirus (avast) and apache was running.</p>
  
  <p>When run on admin mode :</p>
  
  <pre><code>C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password: ***********
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  
  C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password: *
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  
  C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password:
  ERROR 1049 (42000): Unknown database 'localhost'
  </code></pre>
  
  <p>When run on user mode (who is admin also) :</p>
  
  <pre><code>C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password: ***********
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  
  C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password: *
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  
  C:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysql -u root -p localhost
  Enter password:
  ERROR 1049 (42000): Unknown database 'localhost'
  </code></pre>
  
  <p>Not able to start MYSQL Service from Control Panel\All Control Panel Items\Administrative Tools\Service
  Error Message ; WIndows could not start the MYSQL56 service on Local Computer
  Error 1067 THe process terminated unexpectedly</p>
  
  <p>Regards : Msinfo</p>