November 11th, 2004, 04:23 PM
Host 'localhost' is not allowed to connect to this MySQL server
I'm setting up a server for a client and I get this error "Host 'localhost' is not allowed to connect to this MySQL server" whenever I try running a script that talks to MySQL. I used PHPadmin to access the mysql.user table and change the passwords for both root accounts (localhost and any host). I don't know what exactly caused this but I need to fix it. Any help is appreciated.
November 12th, 2004, 01:33 AM
have you run: FLUSH PRIVILEGES ?
Check your privileges, you'll need to allow, eg, root to access via localhost. Use PhpMyAdmin, go to privileges (very small text on the first page) and make sure that user root on host localhost and % has all privileges. If you need to change anything make sure you FLUSH PRIVILEGES.