MySQL connection fail

[tkc]

Hi Guys,

 

I'm a beginner of PHP and MySQL. I got problem when trying to run a PHP file, result as shown below

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'YOURDATABASE'@'localhost' (using password: YES) in C:\xampp\htdocs\TT\dbconnect.php on line 2
can not connect:Access denied for user 'YOURDATABASE'@'localhost' (using password: YES)

 

Below is mine SQL database connection:

 

<?

$conn=mysql_connect("localhost","YOURDATABASE","YOURPASSWORD")

or die("can not connect:".mysql_error());

mysql_select_db("YOURDATABASE",$conn) or die("can not connect to database:".mysql_error());?>

 

 

But I checked the MySQL connection in Dreamweaver, it was sucessful.

 

What should I do?

 

[Barand]

What should I do?

 

 

Use the correct username/password combination.

 

Is the username the same as the database name when you connect with Dreamweaver?

Edited October 27, 2013 by Barand

[tkc]

Thanks for reply.

 

Meaning to say i must use 

 

user name : YOURDATABASE

password : YOURPASSWORD

 

in Dreamweaver MySQL Connection?

 

I tried, but still error, like below:

 

"1045 access denied for user YOURDATABASE@localhost (using password: Yes).

[mentalist]

user name : YOURDATABASE

You need to use username not database name...