Some times, MySQL service doesn’t work due to missing mysql.sock file , then you need to create manually mysql.sock file. Follow the below steps to create mysql.sock file.
First, login your server and check /tmp and /var/lib/mysql , you may see that there is no mysql.sock file(It is called also Symbolic file).
Follow the below steps.
cd /var/lib/mysql/
touch mysql.sock
chmod 1777 mysql.sock
chown mysql.mysql mysql.sock
Create a symlink for the sock file :-
ln -s /var/lib/mysql/mysql.sock /tmp
Once created, then restart Mysql service : service mysql restart
Your Mysql service should be back normal now.
