Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Connect to DB installed into dedicated VPS (private networking) Question Question
Is both HTTP and HTTPS versions should be verified in Webmaster Tools? Question Question

Question

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

Posted July 23, 2017 94.3k views
CentOSMySQLWordPressLinux Commands

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.

Add a comment
salmanafzal
By:
salmanafzal

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Connect to DB installed into dedicated VPS (private networking) Question Question
Is both HTTP and HTTPS versions should be verified in Webmaster Tools? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
5 answers
yazak December 6, 2017

Restart MySQL

service mysqld start

if using MariaDB use

sudo systemctl start mariadb

Reply Report
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 Report
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 Report
salmanafzal July 23, 2017
[deleted]
Reply Report
akshayvirkhare1601 March 7, 2018

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help