PHP to MySQL DB - cannot connect

[shirrasoft]

I am trying to connect to a MySQL db using the following php script (not real user or password), but I keep getting the error msg (below).
Do I have to change permissions? (on what?). Am I missing something here?

<?php
$db = mysql_connect("www.shirrasoft.com","dbuser","dbpassword");
mysql_select_db("wsadmin",$db);
$result = mysql_query("SELECT * FROM mytable",$db);

Warning: Access denied for user: 'dbuser@66.54.199.102' (Using password: YES) in /usr/local/psa/home/vhosts/shirrasoft.com/httpdocs/testMySQL.php on line 9

[cgraz]

That means the credentials you are using are wrong. Try replacing www.shirrasoft.com with localhost (this is what most hosts use). If that still doesn't work, contact your host, give them the credentials you are using, and they should be able to get your problem resolved for you.

Cgraz

[laserlight]

I think that you should try "localhost" for the DB host too.
Conversely, you might be able to use "shirrasoft.com" instead.