At a certain time, now past [Jun.18.2003-11:55:18PM +0200], [EMAIL PROTECTED] spake thusly: > 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.
Passwords from/for what? Are these MySQL user passwords?...or passwords from an application where the userinfo is stored in MySQL? The recommended functions are different for each. If you use GRANT statements for adding MySQL users, it removes the need to use PASSWORD(). http://www.mysql.com/doc/en/GRANT.html http://www.mysql.com/doc/en/Passwords.html If you're talking about a app that looks to MySQL for user credentials use either md5() or sha1(). http://www.mysql.com/doc/en/Miscellaneous_functions.html ~elh -- Eric L. Howard e l h @ o u t r e a c h n e t w o r k s . c o m ------------------------------------------------------------------------ www.OutreachNetworks.com 313.297.9900 ------------------------------------------------------------------------ JabberID: [EMAIL PROTECTED] Advocate of the Theocratic Rule -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]