On Thu, Oct 14, 2004 at 10:47:11AM -0400, Dan Monjar <[EMAIL PROTECTED]> wrote: > --On Thursday, October 14, 2004 10:37:32 AM -0400 Dan Monjar > <[EMAIL PROTECTED]> wrote: > > >--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.
Don't forget to run "FLUSH PRIVILEGES" after doing these changes, else they won't take effect. David
signature.asc
Description: Digital signature
-- 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
