mysql连接被拒绝 密码也对,警告：mysql_connect（）：用户'root'@'localhost'的访问被拒绝（使用密码：是）...

Warning: mysql_connect(): Access denied for user 'root'@'localhost'

(using password: YES) in C:\xampp\htdocs\Login\sessionHandler.php on

line 35

So this is what's on the line 35.

//to make a connection with database

$conn = mysql_connect("localhost", "root", "password") or die(mysql_error());

I don't know whether this is the problem or the code I'm writing.

I have searched for every possible answer but it is not what I was looking for.

this is my code (if the problem is not really on the line 35)//validation error flag

$errflag = false;

//Input Validation

if($_POST['uname'] == '')

{

$errmsg_arr[]='Login ID missing';

$errflag = true;

}

if($_POST['pword'] == '')

{

$errmsg_arr[] = 'Password missing';

$errflag = true;

}

//if there are input validations, redirect back to the login form

if($errflag)

{

$_SESSION['ERRMSG_ARR'] = $errmsg_arr;

session_write_close();

header("location: login.php");

exit();

}

//to make a connection with database

$conn = mysql_connect("localhost", "root", "password") or die(mysql_error());

//to select the targeted database

mysql_select_db("ngchoonching", $conn) or die(mysql_error());

//to create a query to be executed in sql

$username = $_POST['uname'];

$password = $_POST['pword'];

$query = "SELECT * FROM profile WHERE username = '$username' AND password = '$password'";

//to run sql query in database

$result= mysql_query($query, $conn) or die(mysql_error());

//check whether the query was successful or not

if(isset($result))

{

if(mysql_num_rows($result) == 1)

{

//Login successful

session_regenerate_id();

$member = mysql_fetch_assoc($result);

$_SESSION['SESS_MEMBER_ID'] = $member['id'];

$_SESSION['SESS_FIRST_NAME'] = $member['firstname'];

$_SESSION['SESS_LAST_NAME'] = $member['lastname'];

$_SESSION['STATUS'] = true;

session_write_close();

header("location: login-successful.php");

exit();

}

else

{

//login failed

header("location: login-failed.html");

exit();

}

}

else

{

die("Query failed");

}

?>

I use localhost,phpmyadmin,xampp and I don't understand why the access is denied.

解决方案

try $conn = mysql_connect("localhost", "root") or $conn = mysql_connect("localhost", "root", "")