MySQL Error 2002 – Unknown Instance on Ubuntu

MySQLsql serverUbuntu

MySQL server was installed and was running just fine. Today we can't connect to the database via our websites. Command line access using mysql -u username -p also fails. Finally, phpmyadmin fails. 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

service mysql restart
stop: Unknown instance:
start: Job failed to start

Error logs (/var/log/mysql/error.log & /var/log/mysql.err & /var/log/mysql.log) are all empty for the past week. The problem just began today.

I have looked at lots of answers including Ubuntu Error 2002 “Can't connect to local MySql server through socket…” and ERROR 2002 (HY000): Can't connect to local MySQL.

Should I just reinstall mysql server and chalk it up as an unknown error? (horrible idea, obviously).

What is the right course of action to fix immediately and prevent from reoccurring?

Best Answer

I changed the bind-address from the IP to 127.0.0.1. Still not sure why this worked and then all of a sudden stopped. Here is the solution for others.

sudo nano /etc/mysql/my.cnf

change 

bind-address = "127.0.0.1"

And then 

sudo service mysql restart
Related Topic