what's the Basic Encryption method used in mysql

[damod.php@gmail.com]

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

[Martin Mandl - m2m tech support]

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

On Feb 17, 6:00 am, damod....@gmail .com wrote:

what's the Basic Encryption method used in mysql,

You may choose:

http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html

whats iner join whats outer join ,diff b/w.what are the encryption

http://dev.mysql.com/doc/refman/5.0/en/join.html

methods used to encrypt the user name and password.in php/mysql

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

[Rik]

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@g mail.comwrote:

according to http://dev.mysql.com/doc/refman/5.0/en/user-names.html
"MySQL encrypts passwords using its own algorithm."
>

"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