mysql access with php problem

[ptbsG_Man]

Hello i have one tuff problem

ok i was writting a scrip to connect to a MySQL DB witch i have done many-a-time's, but with this script it dose not work heres the code

$connection = mysql_connect("localhost", "username", "password") or die(mysql_error()); 
$db         = mysql_select_db("data") or die(mysql_error()); 
$query1     = "SELECT email,username FROM user";
$rs         = mysql_query($query1) or die(mysql_error());

now when i run that i get

Access denied for user: 'username@localhost' (Using password: YES)

now the strange part if i go to my server and login using the command line i can login using that username and password, use that database, and run SQL on it

Any ideas on what is causing this

Thanks,
Don Gordon

[hi-liter]

i had the same thing happen to me;

i think you need your $connection to be in your second line, like:

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");

[ptbsG_Man]

hmm tried that same error, i took it out because if i took out the die part it would finish the script and zend studio would complaine about it being there , and besides i only have one connection 😕

[hi-liter]

hm. triple check the passwd being used? i was using root w/ the above example. mysql appears not to like the passwd being used. maybe someone else has some ideas too.