php环境localhost密码,php – 用户”@ localhost’拒绝访问(使用密码：否)[复制]

参见英文答案 >

Can I mix MySQL APIs in PHP?                                    5个

尝试使用以下代码连接到localhost sql db(此时不对查询执行任何操作只是希望查询执行)：

$host = "localhost";

$port = 3306;

$socket = "";

$user = "root";

$password = "Password1";

$dbname = "CIIP_WIKI";

$con = new mysqli($host, $user, $password, $dbname, $port);

if(!$con)

{

echo ("db connection failed!");

die ('Could not connect to the database server' . mysqli_connect_error());

}

else {

echo ("db connection established.");

echo ("
");

}

$query = sprintf("SELECT first_name FROM actor WHERE actor_id='1'");

$result = mysql_query($query);

$con->close();

?>

我一直得到以下……

Welcome

db connection established.

Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in C:\Program Files (x86)\EasyPHP-12.1\www\Cisco Wiki\index.php on line 31

Warning: mysql_query(): A link to the server could not be established in C:\Program Files (x86)\EasyPHP-12.1\www\Cisco Wiki\index.php on line 31

为什么这不起作用？