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!