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

Question

Problem :

My problem kicked off when I was unable to log in as the root any more on the mysql install. I was trying to run mysql without the passwords turned on however when I ran my below command :

# mysqld_safe --skip-grant-tables &

I never got my prompt back.

And my screen just looks like below:

root@jj-SFF-PC:/usr/bin# mysqld_safe --skip-grant-tables
030120 11:40:53 mysqld_safe Logging to syslog.
030120 11:40:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

And I never got my prompt to start typing my SQL commands to reset my password.

And when I tried to kill it by pressing the CTRL + C, I face 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

Please follow below steps to resolve your issue.

1. Stop the MySql

           sudo /etc/init.d/mysqld stop

2. Restart MySql or start MySql

           sudo /etc/init.d/mysqld restart or sudo /etc/init.d/mysqld start

3. Make the link like below and give it to your system

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

4. Run the secure installation which will guide you through all the process that you need to follow to configure your mysql

           /usr/bin/mysql_secure_installation