Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server

[James DOdd]

Ok Guys what you seem to have is privelage errors:

check this out here....

http://dev.mysql.com/doc/mysql/en/grant.html

If any of you are running mysql with php+phpmyadmin

you can just go to the home screen >> privelages >> then edit or create the user you require, set the databases they can use and also change where it says host to the computer you will be running this from.

If this will be run from many different locations (ie using a access front end when you don't have a static IP)
then make sure you clear the text box and select Any host (%).

Hope this helps

Its what I did and mine works fine now ;)