Warning: mysql_connect() [function.mysql-connect]: Access denied for user

[1981tarun]

Dear All Friends,

 

My problem is that on the time of connection via PHP with MySQL I write those code which is write in the book or helping website but unfortunately my php page connection in not establish with MYSQL and give the “Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'hostname' (using password: YES) in /home/index.php on line 20”

 

I all ready many times check my username, password, host detail and database detail but every time this warning is coming.

 

I write my code here:

 

<?php

$dbhost = "www.xyz.co.in";

$dbusername = "username";

$dbpassword = "password";

$dbname = "databasename";

$connect = mysql_connect($dbhost, $dbusername, $dbpassword) or trigger_error("SQL Error", E_USER_ERROR);

$db = mysql_select_db($dbname, $connect) or trigger_error("SQL Error", E_USER_ERROR);

$result = mysql_query("select * from images");

while($row=mysql_fetch_array($result))

{

?>

 

This code is running on localhost easily.

Please tell me by which kind of changes this code can work…

 

Regards

[cunoodle2]

Does the URL allow remote connections??

[1981tarun]

I don't know URL allow remote connections

How I Check this.... Please tell me Mr. cunoodle2

[voip03]

DB connection

pl check db name / password/username

[1981tarun]

My all Database name , database username, database password and hosting details are copy on the time of making. Because I use Cpanel ("MySql database Wizard") for database making.