[TriLUG] shooting one's self in the foot with MySQL
Dan Monjar
dan at daijin.dissimulo.com
Thu Oct 14 10:47:11 EDT 2004
--On Thursday, October 14, 2004 10:37:32 AM -0400 Dan Monjar
<dan at daijin.dissimulo.com> wrote:
> --On Thursday, October 14, 2004 10:28:51 AM -0400 "Thomas G. Mayfield"
> <hulett819 at mailcan.com> 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
More information about the TriLUG
mailing list