Re: Password() generates random result in 4.1.0 alpha

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 <salle@xxxxxxxxx>
  / /|_/ / // /\ \/ /_/ / /__   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/bugs?unsub=gcdmb-bugs@xxxxxxxxxxx