MySQL本地连接失败报错求助：无法通过socket连接服务器

Hey there, let's work through this MySQL connection error you're facing. That error message tells us your PHP script can't locate the MySQL server's socket file at /var/run/mysqld/mysqld.sock, so here are actionable steps to fix it:

1. Verify MySQL Server is Running #

First, make sure the MySQL service is actually up and running. Run this command in your terminal:

sudo systemctl status mysql

If it shows "inactive" or "failed", start the service with:

sudo systemctl start mysql

For older systems using init.d, use:

sudo service mysql status
sudo service mysql start

2. Locate the Actual MySQL Socket Path #

The path in the error might not be where MySQL is actually storing its socket file. To find the correct path:

1. Log into your MySQL console:

   mysql -u root -p
   

2. Run this query to get the socket path:

   SHOW VARIABLES LIKE 'socket';
   

   You'll get an output like Variable_name: socket, Value: /tmp/mysql.sock — note down that value.

3. Update Your PHP Connection Code #

Modify your mysqli_connect call to explicitly use the correct socket path. Here's how your code should look (fill in your actual credentials):

<?php
$servername = "fdb..."; // Your existing hostname
$username = "your_db_username";
$password = "your_db_password";
$dbname = "your_database_name";

// Add the socket parameter at the end
$conn = mysqli_connect($servername, $username, $password, $dbname, null, "/path/to/actual/mysql.sock");

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully!";
?>

4. Alternative: Use TCP/IP Connection (If Using Remote DB) #

Since your $servername starts with fdb..., it looks like you might be connecting to a remote database (like a free hosting DB). In this case, you don't need to use a socket at all — switch to a TCP/IP connection by specifying the default MySQL port (3306):

<?php
$servername = "fdb...";
$username = "your_db_username";
$password = "your_db_password";
$dbname = "your_database_name";

// Use TCP/IP with port 3306
$conn = mysqli_connect($servername, $username, $password, $dbname, 3306);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully!";
?>

5. Check Socket File Permissions (If Local DB) #

If you're using a local MySQL server, ensure the PHP process (usually run as www-data for Apache/Nginx) has permission to access the socket file. Check permissions with:

ls -l /path/to/actual/mysql.sock

If needed, adjust permissions or add the web user to the MySQL group:

sudo usermod -aG mysql www-data
sudo systemctl restart apache2 # Or nginx/php-fpm

内容的提问来源于stack exchange，提问作者user9575230