On Mon, Dec 06, 2004 at 04:21:38PM -0600, [EMAIL PROTECTED] wrote: > does anyone know what type of encryption is used in the PASSWORD(str) > function? When would you use the MD5 vs the PASSWORD function? > > We have a campus standard to use the MD5 encryption so I need to confirm > if the PASSWORD function will offer that or not.
As the manual says, the PASSWORD() function should not be used within your application. It is meant only for use with the built-in MySQL privilege tables. Use MD5() or SHA1() for your own applications. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]