警告:mysql_connect():用户'root'@'localhost'的访问被拒绝(使用密码:是) [英] Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES)

问题描述

警告:mysql_connect():用户'root'@'localhost'的访问被拒绝 (使用密码:是)在C:\ xampp \ htdocs \ Login \ sessionHandler.php中 第35行

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\Login\sessionHandler.php on line 35

这就是第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.

这是我的代码(如果问题不在第35行上)

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");
}

?>

我使用localhost，phpmyadmin，xampp，但我不明白为什么访问被拒绝.

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

推荐答案

尝试$conn = mysql_connect("localhost", "root")或$conn = mysql_connect("localhost", "root", "")

这篇关于警告:mysql_connect():用户'root'@'localhost'的访问被拒绝(使用密码:是)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！