Silly DB issue

[Anon]

I realize that this may be a simple problem to solve, but I just cant seem to deal with it.

I have a simple script on a remote server:

<?php
$link = mysql_connect("www.blah.com", "bob", "pass")
or die("Could not connect");
print ("Connected successfully");
mysql_close($link);
?>

problem is, my user 'bob' with password 'pass' generates the error:

Warning: MySQL Connection Failed: Access denied for user: '[e-mail]' (Using password: YES) in /home/sites/site22/web/phpinfo.php on line 8

I gave bob all the permissions (i think).
Thing is, when I try to use my root user, everything works fine.

Why does root work, and not bob? Hrm...

Any help would be appreciated.

-K

[Anon]

It sounds like you are having permission problems, check the user Database, if bob is

[e-mail], can only connect from the local machine, so if you script is on another machine, you will not be able to access it

if your script is on www.bob.com and your mysql server is some where else you have to set the premissions to:

[e-mail]

[tasistro]

Try

$link = mysql_connect("www.blah.com", "bob", "")

Could be bob doesn't have a password set.

Saludos
Gerardo