Cant connect to local mysql server through socket var lib mysql mysql sock

Question

I am getting the above mentioned error when I try to login MySql. I have started the service using:

service mysqld start

And checked the status and verified it is running using this:

mysqladmin -u root -p status

But still getting the error. What is the problem?

Answer 1

Seems like mysql.sock does not exist in the path /var/lib/mysql. First find where this file is using this command:

locate mysql.sock

Once you find the file and the path, create the symlink:

ln -s /<path to file found by previous command>/mysql.sock /var/lib/mysql/mysql.sock