PHP MySQL - 用户访问被拒绝

Question

我知道有大量相关线程，但没有一个能解决我的问题。我在连接到数据库时遇到问题。我收到以下错误:用户 ''@'localhost' 的访问被拒绝(使用密码:NO)

我的 register.php 代码如下:

<?php
require 'config.php';

if(isset($_POST['submit'])){
    //does verification
    $mail1 = $_POST['email1'];
    $mail2 = $_POST['email2'];
    $pass1 = $_POST['pass1'];
    $pass2 = $_POST['pass2'];

    if(($mail1 == $mail2) && ($pass1 == $pass2)){
        //everything is k
        $name = mysql_escape_string($_POST['name']);
        $lname = mysql_escape_string($_POST['lname']);
        $uname = mysql_escape_string($_POST['uname']);
        $email1 = mysql_escape_string($_POST['email1']);
        $pass1 = mysql_escape_string($_POST['pass1']);

        $pass1 = md5($pass1);

        //Checks if username is taken
        $check = mysql_query("SELECT * FROM users WHERE uname = '$uname'")or die(mysql_error());
        if (mysql_num_rows($check)>=1) {
            echo "Username already taken";
        } else {
        mysql_query("INSERT INTO `users` (`first_name`, `last_name`, `username`, `mail`, `password`, `id`) VALUES ('$name', '$lname', '$uname', '$email1', '$pass1', NULL)") or die(mysql_error());
        echo "Registration Successful";
    } }
    else {
        echo "sorry, something doesn't match.";
    }
} else {
    //displays form
    echo $form = <<<EOT
    <form action="register.php" method="POST">
    First Name: <input type="text" name="name" /><br />
    Last Name: <input type="text" name="lname" /><br />
    Username: <input type="text" name="uname" /><br />
    Email: <input type="text" name="email1" /><br />
    Confirm Email: <input type="text" name="email2" /><br />
    Password: <input type="password" name="pass1" /><br />
    Confirm Password: <input type="password" name="pass2" /><br />
    <input type="submit" value="Register" name="submit" />
EOT;
}

?>

我的 config.php 是:

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("MyDB");
?> 

该怎么办？我的PHP版本是5.6.27，MySQL版本是5.6.33

Answer 1

除了出于安全原因您应该使用 mysqli 函数而不是 mysql 之外，您是否检查过:

• 您的 MySQL 用户名是否正确？
• 不需要密码吗？
• 您连接的数据库正确吗？

要做的事:

$db = mysql_connect("localhost", "root", "");
mysql_select_db("MyDB", $db);

您的查询应该是:

$query = mysql_query("SELECT * FROM users WHERE uname = '$uname'", $db);