MySQL missing sock file | /etc/init.d/mysqld start just hangs up

Posted on 2010-01-01
Last Modified: 2013-11-08
Having some major issues with our mysql installation at the moment.
The server was restarted and as a result the mysql service was not started upon reboot.
I am trying to connect using the standard mysql -u root -p command however it is telling me there is a missing mysql.sock file (which hasnt been created because the process was not started)..
When I type /etc/init.d/mysqld start absolutely nothing happens, it just hangs at shell level.
When I type /usr/libexec/mysqld start it starts to do something yet says something about a missing mysql.plugin table and to run mysql_upgrade to fix the issue.. HOWEVER because I cannot run mysql and there is no mysql.sock been created the command fails saying it needs a socket.

Ive tried running mysql in safe mode which worked and I could see the process after running ps aux | grep mysql ,, but when I then try to login to mysql -u root -p it says there is a missing sock file so won't let me in..

PLEASE PLEASE PLEASE can someone respond with any feedback or tips as this is absolutely business critical!

Kind regards
Question by:zzzillion

    Author Comment

    Ok problem solved after seeing another post on the matter. Basically the /var directory had reached HDD capacity, therefore the mysql.sock file could not be created in that directory..

    If anyone else is having a similar issues with the mysql.sock check the capacity of the /var drive.. It was certainly the last thing I was expecting would cause this issue!!

    Accepted Solution

    Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    After running Ubuntu some time, you will be asked to download updates for fixing bugs and security updates. All the packages you download replace the previous ones, except for the kernel, also called "linux-image". This is due to the fact that w…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now