--On Thursday, October 14, 2004 10:28:51 AM -0400 "Thomas G. Mayfield" <[EMAIL PROTECTED]> wrote:
You can use 'mysql --user=root --password=<FOO>', or if you've totally eaten the password field (accomplished that myself about 2 weeks ago), you can open up mysql in "safe" mode and go fix your problems from there.
thanks for the links!
bingo...
"If you change a password by using SET PASSWORD, INSERT, or UPDATE, you must encrypt the password using the PASSWORD() function. If you do not use PASSWORD() for these statements, the password will not work. For example, the following statement sets a password, but fails to encrypt it, so the user will not be able to connect afterward:"
guess what I didn't do.
-- Dan Monjar -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
