MySQL mysqli_connect() 不能连接数据库问题

最新推荐文章于 2025-04-30 10:06:50 发布

weixin_34050519

最新推荐文章于 2025-04-30 10:06:50 发布

阅读量7.8k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python php

原文链接：https://my.oschina.net/guodapeng/blog/3016512

本文探讨了在使用PHP的mysqli扩展连接MySQL数据库时，使用IP地址与使用localhost的不同之处。通过实验发现，直接使用IP地址连接可能会因防火墙设置而失败，而使用localhost则更为稳定。文章还分享了一个临时解决方案：关闭防火墙。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

事情是这样的。这样的代码能行：

$servername = "localhost";
$username = "username";
$password = "password";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
echo "连接成功";

这样的代码能行：

$servername = "localhost";
$username = "username";
$password = "password";

$link = mysqli_connect($servername, $username, $password, 'wxjs');

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);

输出：

Success: A proper connection to MySQL was made! The my_db database is great.
Host information: Localhost via UNIX socket

这样的代码不行：

$servername = "127.0.0.1";
$username = "username";
$password = "password";

$link = mysqli_connect($servername, $username, $password, 'wxjs');

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);

输出：

Error: Unable to connect to MySQL.
Debugging errno: 2002
Debugging error: Permission denied

得出结论：用IP和用localhost是不一样的。

我还找到了一个很变态的方法解决用 IP 不行的，居然是关掉防火墙……

$ sudo setenforce 0

MySQL 新手。幼稚了……

转载于:https://my.oschina.net/guodapeng/blog/3016512