• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 847
  • Last Modified:

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

Hi
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
0
zzzillion
Asked:
zzzillion
1 Solution
 
zzzillionAuthor Commented:
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!!
0
 
EE_AutoDeleterCommented:
zzzillion,
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.

EE_AutoDeleter
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now