encryption in MySQL
-
i want to encrypt the password fied in my database. i use MySQL Server is there anyway to do it by the database or i should make it in my code?
It should be done in your code. Add some salt, encrypt it, then store the encrypted byte stream in the database. When you want to check a users password, add the same salt to the attempted password, encrypt it the same way, then retrieve the password from the database and compare the two byte streams.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
i want to encrypt the password fied in my database. i use MySQL Server is there anyway to do it by the database or i should make it in my code?
-
of course it should be done in the code... for example md5() function in php... and then it's easy to check passwords during authorization...
-
check this article: http://www.codeproject.com/cs/database/md5sql2000.asp may be it will help...