mysql connection prob

Anon

Hi. I am having problems connecting to MySQL and have run out of solutions. I am new at this. I get this error message when I try to open a .php file:

MYSQL Connection Failed: Host "localhost" is not allowed to connect to this MYSQL Server in ../phpMyAdmin/lib.inc.php on line 255. When I go to line 255, i see that it is a bunch of $cfgServer functions (host, user, password). I have MYSQL configured for localhost (everything on same machine), port 3306, and user and password set to my usual permissions.

I have been to google, other help sites, and read through a number of books but can't seem to peg this one.

I'd appreciate any advice. Thanks in advance!

Peter

Anon

When you say you have MySQL configured on the same machine, do you mean you have MySQL installed on the machine to which your keyboard is connected (a silly question, but it's the first logical question to ask)? What I mean is, are you actually working locally (say, on a home machine) or are you working on a web host? If you're on a web host - even though MySQL is installed on that machine - your hostname will not be 'localhost'.

If you are truly working locally, try simply removing the 'localhost' as see what happens. I know that on my Win98 installation I cannot connect if I identify a localhost.

If that doesn't work, post again.

Anon

I am working on my home machine (same keyboard). the setup is php/apache/mysql on linux (mandrake). I removed localhost a while ago and replaced it with a new name (using the old 127.0.0.1). I am thinking that I should have added the new hostname and not replaced the localhost name b/c I think the machine is having problems telling the difference. Thoughts?

Thanks again in advance.