Re: Password() generates random result in 4.1.0 alpha
Sergei Golubchik <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi!
On Aug 13, Alexander Keremidarski wrote:
> Kevin,
>
> Kevin Lee wrote:
> > Hello,
> >
> > In 4.1.0 alpha, I found the result of "SELECT PASSWORD('WHATEVER')" statement
> > is generating random results. Therefore I had to use MD5() to store password to my
> > tables.
It is because in 4.1.0 PASSWORD is adding random salt to the password
string.
But this behaviour will be removed in 4.1.1.
> However you must note that PASSWORD() function was always intended to be used for
> storing MySQL users passwords only and never for using in any other area.
This is correct.
So you were right using MD5 for your passwords.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[email protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]