Hi!
I have a problem with my MySQL server. I can’t connect to MySQL via command line. If I try it, I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
My directory /var/mysql is empty. And if I try
/etc/init.d/mysql restart
I get “[fail]”.
Moreover, if I type
service mysqld restart
I get “mysqld: unrecognized service”.
However, my website (which uses this database) works fine.
Thank you very much ;)
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!
As ahrotahntee mentioned, the correct command to restart a MySql service is:
service mysql restart
One instance when you will see the error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) is when you have run out of room on your hard drive. How is your disk utilization looking? You can check by running:
df -h
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.