Question

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

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.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Restart MySQL

service mysqld start

if using MariaDB use

sudo systemctl start mariadb

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

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