what's the Basic Encryption method used in mysql

what's the Basic Encryption method used in mysql,
whats iner join whats outer join ,diff b/w.what are the encryption
methods used to encrypt the user name and password.in php/mysql

re: what's the Basic Encryption method used in mysql

On Feb 17, 6:00 am, damod....@gmail.com wrote:
You may choose:
http://dev.mysql.com/doc/refman/5.0/...functions.html
http://dev.mysql.com/doc/refman/5.0/en/join.html
according to http://dev.mysql.com/doc/refman/5.0/en/user-names.html
"MySQL encrypts passwords using its own algorithm."

------------------------------------------------
online accounting on bash bases
Online Einnahmen-Ausgaben-Rechnung
http://www.ea-geier.at
------------------------------------------------
m2m server software gmbh
http://www.m2m.at

re: what's the Basic Encryption method used in mysql

On Sat, 17 Feb 2007 07:40:47 +0100, Martin Mandl - m2m tech support
<martin.mandl@gmail.comwrote:"Note: The PASSWORD() function is used by the authentication system in
MySQL Server; you should not use it in your own applications. For that
purpose, consider MD5() or SHA1() instead. Also see RFC 2195 for more
information about handling passwords and authentication securely in your
applications."

PASSWORD() has been changed between different MySQL versions, so should
not be treated as reliable for anything else then actual MySQL users.
--
Rik Wasmus