I'm just new to mysql so I apologize for any silly questions.
My problem started off with me not being able to log in as root anymore into my mysql install. I was attempting to run mysql without passwords turned on... but whenever I would run the command :
I would never get a prompt back... (I was trying to follow the instructions here: http://www.cyberciti.biz/tips/recove...-password.html)
# mysqld_safe --skip-grant-tables &
The screen just looks like this:
and i don't get a prompt to start typing the sql commands to reset the password.
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
when i kill it by doing a ctrl-c, i get the following message:
If I retry the command and leave it long enough, I do get the following series of messages:
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!
But then if i try to log in as root by doing:
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
+ Done mysqld_safe --skip-grant-tables
I get the following error message:
I checked and /var/run/mysqld/mysqld.sock file doesn't not exist. The folder does, but not the file.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Also, I dunno if this helps or not, but I found did a "find / -name mysqld" and it came up with:
I'm just new to linux and mysql, so i don't know if this is normal or not. But I'm including this info just in case it helps ...
/var/run/mysqld - folder
/usr/sbin/mysqld - file
/run/mysqld - folder
any suggestions? I'm running on ubuntu.