title: MySQL: can't access root account
body: <p>I'm running MySQL 5.x on my local Windows box and, using MySQL administrator, I can't connect to the databases I created using the root account. The error I get is:</p>
  
  <blockquote>
    <p>MySQL Error number 1045 Access denied
    for user 'root'@'localhost' (using
    password: YES)</p>
  </blockquote>
  
  <p>I can't recall changing root account credentials, but I know I tried to give other computers on the LAN access to the db by adding their IPs. One thing I did for one of the IPs was to specify access to the account <code>'root'</code> instead of <code>root</code>, i.e. I surrounded root with single quotation chars. All using MySQL administrator. Could this be the reason why i can't login using root?</p>
  
  <p>Also, is there a way to create a new or reset the root account? As previously mentioned, I have full access to my box.</p>
  
  <p><strong>See these questions</strong></p>
  
  <ul>
  <li><strong><a href="https://stackoverflow.com/questions/205614/how-to-change-mysql-root-password-to-default">How to change MySQL root password to default?</a></strong></li>
  <li><strong><a href="https://stackoverflow.com/questions/4371/how-do-i-retrieve-my-mysql-username-and-password">How do I retrieve my MySQL username and password?</a></strong></li>
  <li><strong><a href="https://stackoverflow.com/questions/53482/how-do-i-change-the-password-of-the-root-user-in-mysql">How do I change the password of the root user in MySQL?</a></strong></li>
  </ul>