...

View Full Version : How to store secure password



indrasena
01-24-2007, 09:08 AM
Hi

I want to store password in encrypted format(Non visible i.e *** ) in mysql tables?

Please help me !

Alex!
01-24-2007, 11:14 AM
use md5('the password');

Alex

guelphdad
01-24-2007, 11:33 AM
use SHA1 and not MD5, it is more secure. You will need your password field to be of type char(40) to hold SHA1 passwords.

Alex!
01-24-2007, 12:30 PM
here's some more info:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html

felgall
01-31-2007, 08:34 PM
If you are going to use md5 then apply a salt to the password before calling md5. That will make the md5 method more secure.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum