Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you are getting the error while connecting to mysql database

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Then it could be due to misconfiguration in my.cnf file for easy fix just add a sym link to tmp as below

# ln -s /var/lib/mysql/mysql.sock /tmp