title: Host 'localhost' is not allowed to connect to this MySQL server - grant to root@localhost not working
body: <p>Sorry, I know this is a frequent topic , but...</p>
  
  <p>I have installed a local mysql server on Windows 7 x64 via EzyPHP, but can't log in, except under the <code>--skip-grant-tables</code> option.</p>
  
  <p>Login attempts generate the error: 
  Host 'localhost' is not allowed to connect to this MySQL server.</p>
  
  <p>So I've tried restarting with the --skip-grant-tables option.  This lets me log in as root, and even change the root password. So no problem with the password.  But not to run a grant statement.  This is what happens:</p>
  
  <p><code>GRANT ALL on *.* to 'root'@'localhost' identified by 'ROOT PASSWORD' WITH GRANT OPTION;</code></p>
  
  <p>returns:</p>
  
  <p><code>ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.</code></p>
  
  <p>I've also followed the instructions in other answers, such as here: <a href="https://stackoverflow.com/questions/11513888/phpmyadmin-wont-stop-throwing-1130-host-localhost-is-not-allowed-to-conne">phpMyAdmin won&#39;t stop throwing &quot;#1130 - Host &#39;localhost&#39; is not allowed to connect to this MySQL server &quot;</a> </p>
  
  <p>All I want to do is run a local mysql server to develop a php/mysql app, but this problem seems insurmountable.  Hopefully there is something simple I have missed, which you will be able to point out.</p>
  
  <p>thanks </p>
  
  <p>Dan</p>