Re: Password() generates random result in 4.1.0 alpha
Alexander Keremidarski <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Kevin,
Alexander Keremidarski wrote:
> Results are not random. This is SHA1 based algorithm which produces these hashes.
Some more details in case my first email was not clear enough.
4.1.0 PASSWORD() function adds a random salt to the password.
This behaviour is changed in 4.1.1
Which is one more argument against usage of PASSWORD() in applicatiion. Remember
this funcion is intended for handling MySQL users passwords only.
Best regards
--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[email protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]