请求协助解决ERROR 2002 (HY000)：无法通过套接字'/var/run/mysqld/mysqld.sock'连接本地MySQL服务器问题

Hey there, sorry to hear you're stuck with this frustrating MySQL connection error. Let's work through the most common fixes step by step—this issue usually boils down to MySQL not running, a missing/corrupted socket file, or permission misconfigurations.

Step 1: Check if MySQL is running #

First things first: make sure the MySQL service is actually up and running.

• For systemd-based systems (most modern Ubuntu/Debian, Fedora, etc.):

  sudo systemctl status mysql
  

  If it shows "inactive (dead)", start it with:

  sudo systemctl start mysql
  

  To make it auto-start on boot (optional but recommended):

  sudo systemctl enable mysql
  

• For older init.d systems:

  sudo service mysql status
  

  Start it with:

  sudo service mysql start
  

Step 2: Verify the socket file exists #

The error points directly to /var/run/mysqld/mysqld.sock—let's check if this file actually exists:

ls -l /var/run/mysqld/mysqld.sock

If you get a "No such file or directory" error, try restarting MySQL first (the socket is usually created automatically when the service starts):

sudo systemctl restart mysql

If it still doesn't show up, move to Step 4 to check your config paths.

Step 3: Fix socket file permissions #

Even if the socket exists, incorrect permissions can block access. The socket and its parent directory should be owned by the mysql user/group.

Check the directory permissions:

ls -l /var/run/mysqld/

If the owner isn't mysql:mysql, fix it with:

sudo chown mysql:mysql /var/run/mysqld/
sudo chmod 755 /var/run/mysqld/
sudo systemctl restart mysql

Step 4: Ensure config files have matching socket paths #

MySQL's server and client configs need to agree on where the socket file lives.

1. Open the server config (usually /etc/mysql/mysql.conf.d/mysqld.cnf or /etc/my.cnf):

   sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
   

   Look for the [mysqld] section and confirm:

   socket = /var/run/mysqld/mysqld.sock
   

2. Open the client config (often /etc/mysql/my.cnf or /etc/mysql/conf.d/mysql.cnf):

   sudo nano /etc/mysql/my.cnf
   

   Check the [client] section and make sure its socket parameter matches the server's path. If not, update it to match, save, and restart MySQL.

Step 5: Bypass the socket with TCP/IP connection #

If socket issues persist, try connecting via TCP/IP instead to rule out other problems:

mysql -h 127.0.0.1 -u your_username -p

Replace your_username with your actual MySQL username. If this works, the issue is definitely related to the socket file or its configuration—go back to Steps 2-4 to resolve that.

Step 6: Reinstall MySQL (last resort) #

If none of the above work, your MySQL installation might be corrupted. Warning: This will delete all your databases—backup /var/lib/mysql first if you have important data!

# Purge existing MySQL packages
sudo apt remove --purge mysql-server mysql-client mysql-common
sudo apt autoremove
sudo rm -rf /var/lib/mysql /etc/mysql

# Reinstall MySQL
sudo apt install mysql-server mysql-client

After reinstalling, set up your users and databases again (restore from backup if you made one).

内容的提问来源于stack exchange，提问作者Anh Tuan Vo