php 警告：mysql_connect()：用户“root”@“localhost”的访问被拒绝（使用密码：YES）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23230729/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES)
提问by Cheryl Perry
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\Login\sessionHandler.php on line 35
警告: 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.
这就是第 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)
这是我的代码（如果问题不是真的在第 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.
我使用 localhost、phpmyadmin、xampp，但我不明白为什么访问被拒绝。
回答by onedevteam.com
try $conn = mysql_connect("localhost", "root")or $conn = mysql_connect("localhost", "root", "")
尝试$conn = mysql_connect("localhost", "root")或$conn = mysql_connect("localhost", "root", "")
