Access denied for user 'xxxxxxx@localhost' using password[yes]

sujithaoscommerce · August 24, 2011

Hi, this is my php page

<?php

$hostname = "purehealths.com";

$db_user = "pureheal_amulya";

$db_password = "amulya";

$database = "pureheal_wordpress";

$db_table = "login";

echo mysql_error();

echo "hi";

mysql_connect("purehealths.com","pureheal_amulya","amulya") or die("can't connect");

echo mysql_error();

mysql_select_db("pureheal_wordpress") or die("canot select db");

echo mysql_error();

?>

<html>

<head>

<title>How To Insert Data Into MySQL db using form in php</title>

</head>

<body>

<?php

$userid=mysql_real_escape_string($_POST['uname']);

$pass=mysql_real_escape_string($_POST['pwd']);

$sql="select * from login where username='$userid' and password='$pass'";

$result = mysql_query($sql);

if(!$result)

{

echo "could not successfully run query";

exit;

}

if(mysql_num_rows($result)==0){

echo "<font face='verdana' size='2' color='green'>login failed</font>";

}

else{

while($row=mysql_fetch_array($result,MYSQL_ASSOC)){

echo "<table colspan='2' width='100%'><tr> <td ><img src='C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\RRHealth_Logo copy.gif' width='100' height='100'/></td><td align='center'>"."<b><font face='verdana' size='4' color='green'>Preventive Health Care Admininstration </font></b></td> <td> <a href='http://localhost/build2.php'>Log Out </a></td>";

echo "<tr><td><font face='verdana' size='2' color='black'>Hi</font>".",<font face='verdana' size='4' color='orange'>".$row['name']."</font></td></tr>";

#echo "<tr><td align='center'>"."<b><font face='verdana' size='4' color='green'>Preventive Health Care Admininstration </font></b>"."</td></tr></table>";

#echo "<tr><td>"."YOUR INFORMATION IS :<br>"."</td></tr></table>";

echo "<table align='center' border='0'><tr>"."<td>";

printf("<font face='verdana' size='3'>UserName:</font> %s<br />",$row["username"]);

printf("<font face='verdana' size='3'>password:</font> %s<br />",$row["password"]);

printf("<font face='verdana' size='3'>E-Mail:</font> %s<br />",$row["email"]);

printf("<font face='verdana' size='3'>Phone Number:</font> %s<br />",$row["phnum"]);

printf("<font face='verdana' size='3'>Address:</font> %s<br />",$row["address"]);

printf("<font face='verdana' size='3'>City:</font> %s<br />",$row["city"]);

printf("<font face='verdana' size='3'>State:</font> %s<br />",$row["state"]);

printf("<font face='verdana' size='3'>Services:</font> %s<br />",$row["service"]);

echo "</td></tr></table><br><br>";

$id1=$row["id"];

}

include 'library/config.php';

include 'library/opendb.php';

include 'library/closedb.php';

?>

</body>

</html>

This is my html page test.html

username:<input type="text" name="uname">

password:<input type="password" name="pwd">

</form>

I have the host detailes for my website.I have to add this to server.I created database in cpanel.username and password are same but iam getting warning as

mysql_connect() [function.mysql-connect]: Access denied for user 'pureheal_amulya'@'69.93.204.32' (using password: YES) in /home/pureheal/public_html/test1.php on line 20.

Please give me a solution to get rid from this.Plzzzzzzzz iam trying from so many days.

Thank you inadvance.And sorry for looooooooong description

Posted August 24, 2011 · August 24, 2011

Your question has nothing to do with osCommerce, I suggest you refer to W3 Schools for SQL, PHP, HTML tutorials.

Chris

Taipo · August 24, 2011

Are you trying to edit an osCommerce or a Wordpress database, because if its Wordpress then as Chris alluded to, this is not the place for Wordpress support.

Access denied for user 'xxxxxxx@localhost' using password[yes]

Recommended Posts

sujithaoscommerce

Guest

Taipo

Archived

Browse

Activity