ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

July 23, 2017 44.5k views
WordPress MySQL Linux Commands CentOS
salmanafzal
By:
salmanafzal

Hi,
I currenty have a LAMP, running on Centos, everything was fine, but my MYSQL is not working.

When i try to connect via

mysql -u root -p

I get the error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Note: This error has been occur, when i will install WordPress theme on my Site, after this, i will click on the Import Demo Button to import the FrontPage, then error occur.

Log In to Comment
5 Answers
salmanafzal July 23, 2017

@Mohsen47

Dear, When i will enter this command on PuTTy, i get an error
tail: cannot open ‘/var/log/mysql/error.log’ for reading: No such file or directory
Note: I have 512 MB Ram Server with lot of Bandwidth Available. I Will Deploy Server and Start Installing WordPress, everything was fine, but when i will try to install theme, after this it shows an database error.

Reply
  • hansen July 23, 2017

    Hi @salmanafzal

    You need at least 1GB RAM to run WordPress - even more so, when you import demo data.
    You can resize your droplet after shutting it down via the control panel.

Mohsen47 July 23, 2017

@salmanafzal

The error message means that mysql process has crashed for some reason please share your mysql error log by giving as the output of this command

tail -20 /var/log/mysql/error.log

My guess is that your droplet is running out of memory how much memory did you allocate for it?

Hope this helps.

Reply
salmanafzal July 23, 2017
[deleted]
Reply
yazak December 6, 2017

Restart MySQL

service mysqld start

if using MariaDB use

sudo systemctl start mariadb

Reply
akshayvirkhare1601 March 7, 2018

lsof -i:3306
kill the running process with
kill -9 PID
then restart the mysql service

Reply
Have another answer? Share your knowledge.

Related Questions