It's not recommended because in MySQL 4.1, it returns a different result each time PASSWORD() is used, with the same input string. For MD5/SHA1 function, take a look here :
http://www.mysql.com/doc/en/Miscellaneous_functions.html Jocelyn ----- Original Message ----- From: "development" <[EMAIL PROTECTED]> To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]> Cc: "'Mysql'" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 12:38 AM Subject: RE: Can we crypt passwords on MySQL Jocelyn Why is that not recommended ? Do you have any links for how to encrypt the password with MD5 ? Freddie -----Original Message----- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED] Sent: Freitag, 27. Juni 2003 00:19 To: [EMAIL PROTECTED]; Grégoire Dubois Cc: 'Mysql' Hi, Using PASSWORD function to crypt password is not recommended, it's mainly used for internal mysql password encryption. Prefer using MD5/SHA1 functions to encrypt a password. Regards, Jocelyn ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Grégoire Dubois" <[EMAIL PROTECTED]> Cc: "'Mysql'" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 12:14 AM Subject: RE: Can we crypt passwords on MySQL > There is a PASSWORD('your_clear_text_password_here') function you can use > wherever you define a new password. See the manual for more. > > Lian > > > > -----Original Message----- > > From: Grégoire Dubois [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 19, 2003 12:55 AM > > Cc: 'Mysql' > > Subject: Can we crypt passwords on MySQL > > > > > > Hi all, > > > > Is it possible to crypt the passwords on MySQL. If yes, how does it > > work, and how is it to be implemented. > > Any link would be great. > > > > Thank you. > > Grégoire Dubois. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]