#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2002
    Posts
    195
    Rep Power
    13

    Exclamation 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.
  2. #2
  3. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
    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.

IMN logo majestic logo threadwatch logo seochat tools logo