#1130 - Host ‘localhost’ is not allowed to connect to this MySQL server
- by Raph
I accidently changed the "host" value for the root user inside of the user table for mysql.
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 anymore.
I am running windows XP // apache //
I have tried the following solutions but they didn't work:
http://serverfault.com/questions/92870/1130-host-localhost-is-not-allowed-to-connect-to-this-mysql-server