MySQL missing sock file | /etc/init.d/mysqld start just hangs up
Posted on 2010-01-01
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!