Can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock'

Question

Problem :

My problem started with me when I was unable to log in as root any more on the mysql install. I was trying to run mysql without passwords turned on... but whenever I ran the below command

# mysqld_safe --skip-grant-tables &

I would never get my prompt back to just start typing my SQL commands to reset my password.

When I try to kill it by pressing ctrl +c I get the below message:

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Answer 1

I had also faced the same error in the recent past.

This error usually occurs due to the multiple installations of mysql.

You need to Run the below command :

ps -A|grep mysql

Kill your process by using below command :

sudo pkill mysql

And after that you need to run the below command :

ps -A|grep mysqld

Also Kill your process by running below command :

sudo pkill mysqld

Now you are completely set just you need to run the below commands :

service mysql restart

mysql -u root -p

That’s it you are all set now !! Have a very well working Mysql again !!