Question

mysqld: unrecognized service

Posted August 11, 2014 29.9k views

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 ;)

Add a comment
dev752684
By:
dev752684
Add a comment
1 comment
  • ahrotahntee August 11, 2014
    Reply Report

    The service name is ‘mysql’ not 'mysqld’. Please confirm the status of the service by typing 'service mysql status’

    Also you indicated that you check the /var/mysql directory, but the socket file should be located in /var/run/mysqld/ directory.

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.

×
2 answers
asb August 11, 2014

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
Reply Report
dev752684 August 14, 2014

Hi!

Thank you very much! I’ve solved this! ;)

Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help