php - 使用PHP远程访问MySQL数据库

Question

我正在尝试远程访问数据库。我可以从服务器本身访问它，但我需要远程访问它，并且正在我的计算机上使用 XAMPP 来执行此操作。

我添加了数据库用户从我的 IP 访问数据库的可能性(也尝试使用 %)。这是代码:

$servername = $websiteIP; //e.g. xx.xx.xxx.xxx, also tried website URL and URL to phpMyAdmin 
$username = 'username';
$password = 'password'; 
$dbname = 'dbname';
$port = '3306';
$conn = new mysqli($servername, $username, $password, $dbname);
// also tried $conn = new mysqli($servername, $username, $password, $dbname, $port);

但我总是收到此错误:

Warning: mysqli::mysqli(): (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in ...

除非我使用 $servername = $urlToMyPhpAdmin;然后我收到此错误:

Warning: mysqli::mysqli(): MySQL server has gone away in xxx on line 10. Warning: mysqli::mysqli(): Error while reading greeting packet. PID=102448 in xxx on line 10. Warning: mysqli::mysqli(): (HY000/2006): MySQL server has gone away in xxx on line 10

我错过了什么？

Answer 1

数据库与网站位于同一服务器上吗？您可能需要数据库主机的 IP 或地址，而不是网站(或 PHPMyAdmin)。我将进入 PHPMyAdmin 并运行以下查询，取自 this答案:

从 GLOBAL_variables 中选择*，其中variable_name如“主机名”；

并尝试使用结果作为您的$servername