MySQL connect string and variables

Anon

Hi All,

I've been trying to run a mysql_connect using variables, but seem to be having problems. EX., when I use

$host = "localhost";
$user = "ross";
$pwd = "password";

sql_id = mysql_connect($host,$user,$password);

I get an error which states:

Warning: Access denied for user: 'ross@localhost' (Using Password: Yes)

1044: Access denied for user. '@' to database 'test_db'

On the other hand, if I hard code in the same connection parameters, I can connect with no problems.

I'm new to PHP, so this might seem trivial, but I just can't get the darn thing to work.
Any help would be appreciated,

Thanks,
Ross

Anon

You named your variable $pwd but used $password in your mysql_connect statement. Plus you forgot a $ in front of sql_id.

Anon

I apologize for being sloppy in my example.
It should have read:

$host = "localhost";
$user = "ross";
$pwd = "password";

$sql_id = mysql_connect($host,$user,$pwd);

Thanks for pointing that out. I double checked and the code is correct, but I'm still getting that error. Could this possibly have anything to do with the fact that when I hard code the parameters, it uses quotes? And when I use variables, it passes their values without the quotes?

Again, sorry for not double checking my example.

Anon

Hi,
I've seen this error a few times. Your php script is correct (after you fixed it). This error has to do with not setting up the database with the correct authorities. You need to go into mysql and set the permissions correctly.
Try:
mysql <enter>
GRANT ALL PRIVILEGES ON . TO ross@localhost IDENTIFIED BY 'password' WITH GRANT OTPION; <enter>
GRANT ALL PRIVILEGES ON . TO ross@"%" IDENTIFIED BY 'password' WITH GRANT OTPION; <enter>
quit<enter>
**If this does not work, please contact your ISP.