php - 从本地主机连接到服务器数据库

Question

我正在尝试做的是从本地主机连接到服务器数据库。

$host = 'http://www.my-domain.com/phpmyadmin/';
$user = 'u5er';
$pass = 'pa55w0rd';
$db = 'db_name';

$con = mysqli_connect($host,$user,$pass,$db) or die("Error " . mysqli_error($con));
$sql = "SELECT col FROM test WHERE id = '1'";

$result = mysqli_query($con,$sql);

错误

Warning: mysqli_connect(): in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362

Warning: mysqli_connect(): in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362
Error

可以解决吗？如何确定我的服务器是否允许外部连接？以及如何定义应该允许从哪些 IP 地址访问数据库？

感谢您的任何建议。

编辑:好的，我已经将主机更改为my-domain.com，现在它报告以下错误。我的 IP 无法访问 MySQL 服务器...

Warning: mysqli_connect(): (HY000/1130): Host '88.146.210.54' is not allowed to connect to this MySQL server in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362
Failed to connect to MySQL: Host '88.146.210.54' is not allowed to connect to this MySQL server
Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 368

Answer 1

如果您将本地主机文件上传到网络服务器，一些主机提供商，也使用“localhost”作为主机名

$host = 'localhost';
$user = 'u5er';
$pass = 'pa55w0rd';
$db = 'db_name';

当你没有配置主机授权访问数据库时出现“主机'XXX.XXX.XXX'不允许连接到这个MySQL服务器”