Edit Question - KnowledgeHub

Title Body

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & I would never get the prompt back. I was trying to follow these instructions to recover the password . The screen just looks like this: root@jj-SFF-PC:/usr/bin# mysqld_safe --skip-grant-tables 120816 11:40:53 mysqld_safe Logging to syslog. 120816 11:40:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql and I don't get a prompt to start typing the SQL commands to reset the password. When I kill it by pressing CTRL + C , I get the following 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! If I retry the command and leave it long enough, I do get the following series of messages: root@jj-SFF-PC:/run/mysqld# 120816 13:15:02 mysqld_safe Logging to syslog. 120816 13:15:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120816 13:16:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended [1]+ Done mysqld_safe --skip-grant-tables root@jj-SFF-PC:/run/mysqld# But then if I try to log in as root by doing: # mysql -u root I get the following error message: ERROR 2002 (HY000): Can't connect to local MySQL ser

Tags (comma-separated) Cancel