By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,216 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,216 IT Pros & Developers. It's quick & easy.

what's the Basic Encryption method used in mysql

P: n/a

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

Feb 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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/...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

Feb 17 '07 #2

P: n/a
Rik
On Sat, 17 Feb 2007 07:40:47 +0100, Martin Mandl - m2m tech support
<ma**********@gmail.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
Feb 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.