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

July 23, 2017 210 views
WordPress MySQL Linux Commands CentOS

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.

3 Answers

@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.

  • 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.

@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.

Have another answer? Share your knowledge.