PHP 以 Apache 用户而不是指定用户的身份连接到 MySQL

Question

我正在尝试使用 PHP 连接到 MYSQL 数据库。我有这个连接到数据库:

<?php
$servername = "localhost";
$username = "orbital";
$password = "XXXXXXXX";
$dbname = "helios";

function establishConnection() {
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    return $conn;
}?>

但是，每当我调用 externalConnection() 时，我都会得到:

Connection failed: Access denied for user 'webmaster'@'localhost' (using password: NO)

webmaster 是我的机器上运行 Apache 的用户。为什么使用没有密码的网站管理员用户而不是指定的“orbital”用户？

Answer 1

您需要将数据库变量传递给函数。不要使用global关键字；将它们作为参数传递。

<?php
$servername = "localhost";
$username = "orbital";
$password = "XXXXXXXX";
$dbname = "helios";

function establishConnection($servername, $username, $password, $dbname) {
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    return $conn;
}?>