Re: Access denied for user 'root'@'localhost' (using password: YES)
I am having this problem too! Exept I tried EVERYTHING! I tried reseting my password, I tried different usernames, I have all the correct info in and heres the error...
---------------------------------------------------------------------
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Challengefun'@'localhost' (using password: YES) in /home2/challeng/public_html/register.php on line 47
Access denied for user 'Challengefun'@'localhost' (using password: YES)
---------------------------------------------------------------------
PHP code...
---------------------------------------------------------------------
<?php
// Connects to your Database
mysql_connect("localhost", "Challengefun", "mitch") or die(mysql_error());
mysql_select_db("challengefun") or die(mysql_error());
//This code runs if the form has been submitted
if (isset($_POST['submit'])) {
//This makes sure they did not leave any fields blank
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] ) {
die('You did not complete all of the required fields');
}
// checks if the username is in use
if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);
//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}
// this makes sure both passwords entered match
if ($_POST['pass'] != $_POST['pass2']) {
die('Your passwords did not match. ');
}
// here we encrypt the password and add slashes if needed
$_POST['pass'] = md5($_POST['pass']);
if (!get_magic_quotes_gpc()) {
$_POST['pass'] = addslashes($_POST['pass']);
$_POST['username'] = addslashes($_POST['username']);
}
// now we insert it into the database
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST['username']."', '".$_POST['pass']."')";
$add_member = mysql_query($insert);
?>
<?php
}
else
{
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0">
<tr><td>Username:</td><td>
<input type="text" name="username" maxlength="60">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table>
</form>
<?php
}
?>
<h1>Registered</h1>
<p>Thank you for registering! - You may now login</a>.</p>
---------------------------------------------------------------------
Subject
Written By
Posted
September 24, 2007 04:57AM
September 03, 2007 01:08AM
Re: Access denied for user 'root'@'localhost' (using password: YES)
July 19, 2008 12:48PM
September 11, 2008 09:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.