Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Exclamation 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.


  2. #2
    Join Date
    Jul 2007

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts