How to solve the error “connect to local MySQL server through socket”

Answered 2 years ago (Jan 27, 2021) by Eldernode staff

Dear Marquez,

While you are receiving this error, it means that you have no MySQL service running or maybe you have detected a wrong Linux file socket or TCP/IP port.

1- First, you need to ensure your MySQL database services. To do this, run the command below:

ps xa | grep mysqld | grep -v mysqld

2- If you see no output, it means MySQL is not running. So, the clients cannot connect it. To start MySQL service, type:

sudo systemctl start mysql #Debian/Ubuntu  sudo systemctl start mysqld #RHEL/CentOS/Fedora  

3- Then, to check the status of service, run:

sudo systemctl status mysql #Debian/Ubuntu  sudo systemctl status mysqld #RHEL/CentOS/Fedora  

4- If you see MySQL is failed in the above output, you must restart and check it again:

sudo systemctl restart mysql  sudo systemctl status mysql  

2-1- But if MySQL is running and you still view the error, you should check for TCP/IP port.

ps xa | grep mysqld | grep -v mysqld

2-2- To check which port is listening on the server, run:

sudo netstat -tlpn | grep "mysql"

Feel free to ask any further questions or find some related articles on:

https://blog.eldernode.com/mysql-queries-troubleshooting/

https://blog.eldernode.com/install-mysql-on-linux-ubuntu-20-04/

https://blog.eldernode.com/repair-databases-in-mysql/