PHP MySQL 身份验证错误

Question

我创建了一个 html 表单 (demo.html) 并将其值发布到一个 php 文件 (demo1.php)。然后我在 MySQL 中创建了数据库并在 php 文件 (demo1.php) 中编写了连接代码，但它给出了以下错误

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\demo1.php on line 8 Error connecting to mysql

<?php
// contact to database
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
//$conn = mysql_connect("localhost","root","password") or die ('Error connecting to mysql');

$dbname = 'test';
mysql_select_db($dbname,$conn);

//$connect = mysql_connect("localhost", "root", "pass") or die ("Error , check your server connection.");

//mysql_select_db("test");



//Get data in local variable

$v_name=$_POST['name'];

$v_email=$_POST['email'];

$v_msg=$_POST['msg'];



// check for null values

if ($v_name==""  or $v_msg=="")

echo "All fields must be entered, hit back button and re-enter information";

else{

$query="insert into contact(name,email,msg) values('$v_name','$v_email','$v_msg')";

mysql_query($query)  or die(mysql_error());

echo "Your message has been received";

mysql_close($conn);

}

?>

Answer 1

用户 root 的密码不正确。

本地(家庭)服务器上的默认密码为空，所以我认为这可以帮助:

$dbpass = '';