Can't connect to local MySQL server through socketmysql -u root -p 正常登入操作MySQL Server 建立的 Unix Socket 檔案路徑與 PHP/MySQL 客戶端庫預期路徑不同。常見於:
mysql -u root -p -e "SHOW VARIABLES LIKE 'socket';"
# 輸出範例
+---------------+-----------------------------+
| Variable_name | Value |
+---------------+-----------------------------+
| socket | /var/run/mysqld/mysqld.sock |
+---------------+-----------------------------+
; php.ini
; 找到 [MySQL] / [mysqli] / [pdo_mysql] 區塊
mysql.default_socket = /var/run/mysqld/mysqld.sock
mysqli.default_socket = /var/run/mysqld/mysqld.sock
pdo_mysql.default_socket = /var/run/mysqld/mysqld.sock
或運行時動態指定:
$pdo = new PDO("mysql:host=localhost;dbname=test;unix_socket=/var/run/mysqld/mysqld.sock", $user, $pass);
$mysqli = new mysqli("localhost", $user, $pass, "db", 3306, "/var/run/mysqld/mysqld.sock");
systemctl reload php8.2-fpm
# 或
systemctl restart httpd
connect_errno) {
echo "連線失敗: " . $mysqli->connect_error . "\n";
// 嘗試無 socket 參數
$mysqli2 = @new mysqli("localhost", "root", "pass", "db");
echo "無 socket 參數: " . ($mysqli2->connect_errno ? "失敗" : "成功") . "\n";
} else {
echo "連線成功!\n";
$mysqli->close();
}
| 現象 | 檢查項目 | 解決 |
|---|---|---|
| 權限拒絕 | Socket 檔案權限、SELinux | chmod 777 socket 目錄、setsebool -P httpd_can_network_connect_db 1 |
| skip-networking 開啟 | my.cnf 有 skip-networking | 註釋或改用 127.0.0.1 TCP 連線 |
| PHP 版本不匹配 | php-mysqlnd vs libmysqlclient | 統一用 mysqlnd (原生驅動) |
| 主機名解析 | /etc/hosts localhost 解析 | 確保 127.0.0.1 localhost |