[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