Re: [909linux] "mysqld_safe" hangs when I try to reset MySQL's root password

[Joel Brauer]

no, that statement is for logging in once you've changed it. What you need to do is log in as root with no password. That's what the -- skip-grant-tables allows you to do. Then you can do the command to change the root password(I forget off the top of my head what it is). After which you shut the service down and restart it normally and login normally using mysql -u root -p.

Make sense?

Joel Brauer
Manager IS
Communications and Web Technologies
Loma Linda University
pager: jbra...@sprintpcs.com
jbra...@llu.edu



On Mar 21, 2007, at 12:50 PM, Roger E. Rustad, Jr. wrote:

Did you kill off the --skip-grant-tables instance first?


or the other.

Other than that, you may have entered the password incorrectly in one place

I did, but that didn't seem to work.  I assumed that the last " mysql
-u root -p" statement would let me reset it to whatever I wanted.
_______________________________________________
909linux mailing list
909linux@909linux.org
http://909linux.org/cgi-bin/mailman/listinfo/909linux

PGP.sig
Description: This is a digitally signed message part