var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: unable to reset root password
I'm trying to reset my mysql password on my server, and i'm getting the following error 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!
that's what i get when i try to run mysqld_safe --skip-grant-tables
I'm actually trying to following the instructions for resetting root password found here:
Recover MySQL root Password
What happens when i run the initial "mysqld_safe" command is that i never get a prompt back so that I can start typing the sql statements. the screen 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 it just sits there.
when i do a ctrl-c to kill the request, i get the above error message dumped out.
some additional things i checked...
i also checked to see if the mysqld.sock file exists... and it doesn't!
maybe that's the problem?
I'm going to google it to see how it gets created etc . but if you have any suggestions in the interim I'd appreciate it.