At 15:02 -0700 2/25/04, Colleen Dick wrote:Ah... so I shouldn't use it except for the grant tables.. I guess I just carried my admin habits over into the app arena. OK then, MD5 is
I'm sure this is in the manual somewhere or in the archives, but I'm not finding it and I bet someone easily knows the short answer:
Using 3.23 setting a varchar field to PASSWORD("secret") Having altered nothing regarding encryption in the server what is the default encryption type for PASSWORD? cuz I told PEAR::Auth that the encryption type is md5 and if that is wrong that could be the reason why it is not working.
If you want MD5 encryption, you could use the MD5() function.
PASSWORD() uses encryption that is intended for use with MySQL account management, not for general application encryption.
http://www.mysql.com/doc/en/Encryption_functions.html
fine with me. Poof they're all changed. And the users authenticate too. THANKS FOR YOUR ANSWER!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
