PHP Troubles

[coltrane]

Classic SQL connection problems
I have even gone so far as to use this as a syntax :

<?php

$link = mysql_connect("mysql_host", "mysql_login", "mysql_password&quot
or die("Could not connect"
print "Connected successfully";
mysql_select_db("my_database&quot
or die("Could not select database"


?>

and I STILL get

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /var/www/html/hello.php on line 19

[Feztaa]

I'm not an expert, but I think you have to configure your user rights for mysql. you have to give root a password, and you have to use it

Don't ask me how to do that, though. I've only had to do it twice, and I always forget the day after and end up asking njcajun from LNO how to do it

[coltrane]

Ive done that already.

I mean, it doesnt matter WHAT i put in the connect syntax, I get the same error.

[redhead]

$link=mysql_connect("localhost", "root", "") or die("Error connecting");

Should work, you'sure you havn't assigned a password for root?, and that you can connect to the mysql-db with: mysql -u root -p ? With no password given at the prompt.
This is why the error your talking about happens:

Redhead@smaug{103} ~> mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Redhead@smaug{105} ~> mysql -u root -p
Enter password: <my secret password>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 251 to server version: 3.23.37

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql>

Seems like your mysql-db want's a password for root, but you leave it blank.

[coltrane]

ummm

the php file was owned by root, and not the users group

that caused the problem

Im going to sleep now...............