title: Added password to root, locked out of phpmyadmin
body: <p>Using phpmyadmin, I changed the password for user root (both the localhost entry and the 127.0.0.1 entry) from blank to "password".  I was then locked out of phpmyadmin, getting the 1130 error: "Host ‘localhost’ is not allowed to connect to this MySQL server"</p>
  
  <p>I did a bunch of searching on stackoverflow and found a solution that gets me back into phpmyadmin:</p>
  
  <p>I simply add the line "skip-grant-tables" to the [mysqld] section of "my.ini".  </p>
  
  <p>But that seems like a bad solution, like I am just circumventing the problem rather than fixing it. I also tried another solution in which I add my username and password to "config.inc.php" in this section:</p>
  
  <pre><code>$cfg['Servers'][$i]['user'] = 'root';
  $cfg['Servers'][$i]['password'] = 'mypass';
  </code></pre>
  
  <p>but that has no effect.  So my questions are:</p>
  
  <ol>
  <li><p>Why would adding a password to root lock me out of phpmyadmin in the first place? Shouldn't it just bring me to a login screen?</p></li>
  <li><p>What is the proper way to fix this?</p></li>
  </ol>
  
  <p>Thanks
  Jonah</p>