title: #1130 - Host ‘localhost’ is not allowed to connect to this MySQL server
body: <p>I accidentally changed the "host" value for the root user inside of the user table for mysql.</p>
  
  <p>I need to change it back to localhost because I changed it to arancillary2125 (my other machines DNS name) but I cannot access mysql (from PHPMYADMIN or command prompt) due to "localhost" not having permissions any more.</p>
  
  <p>I am running windows XP // apache // </p>
  
  <p>I have tried the following solutions but they didn't work:</p>
  
  <p><a href="https://serverfault.com/questions/92870/1130-host-localhost-is-not-allowed-to-connect-to-this-mysql-server">https://serverfault.com/questions/92870/1130-host-localhost-is-not-allowed-to-connect-to-this-mysql-server</a></p>