So it's a future thing since I can see MySQL is only at 4.0.13 now. Anyway, I do prefer (hopefully there are others too ;) inserting directly into user, db, host,... tables instead of using GRANT, so for this case I (still) can use PASSWORD(), right ?!
BTW, maybe I'm missing something but what could be the use for a password function returning different results with the same input? I mean, can one using the encrypted result do anything with it after ? A comparison between encrypted results looks in this case unlikely to yeld a result like: "yes the password is good". Thanks, Lian > -----Original Message----- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 1:41 AM > To: [EMAIL PROTECTED] > Cc: 'Mysql' > Subject: Re: Can we crypt passwords on MySQL > > > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]