无法用特定端口从php连接mysql

Question

我有MySQL8.0.15用于windows，我试图从远程php webSite连接，但总是

2002:拒绝连接

用于测试连接的代码非常简单。

$dbHost = "HOST";
$dbUser = "root";
$dbPass = "password";
$dbDB = "DBNAME";
$dbPort = "9999";
echo "Conectando a $dbHost,$dbUser,$dbPass,$dbDB,$dbPort ";


$link = mysqli_connect($dbHost,$dbUser,$dbPass,$dbDB,$dbPort);

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

echo "Success: A proper connection to MySQL was made! The my_db database is great." . PHP_EOL;
echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;

mysqli_close($link);

我还尝试了主机:port和p:host:port，并且总是收到相同的错误消息。

Answer 1

如果要更改MySQL端口，则必须通过设置port=<YOUR PREFERRED PORT>来编辑MySQL服务器上的port=<YOUR PREFERRED PORT>配置文件，然后检查端口是否被转发，最后重新启动MySQL服务器。