Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
nasreen_laghari
Starting Member
3 Posts |
Posted - 2008-01-08 : 17:12:44
|
Hi, I wonder if it is possible to retrieve encrypted password somehow? Like I have saved password (blueRays) in encrypted formate. How can I retrieve it "where password='blueRays' "?Regards |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-08 : 17:45:33
|
Use your unencrypt function to decrypt the encrypted passwords in the where clause.where unencrypt_function(password) = 'blueRays' CODO ERGO SUM |
|
|
nasreen_laghari
Starting Member
3 Posts |
Posted - 2008-01-08 : 19:25:13
|
ohhh... didnt work :(I used below command to encrypt the password:insert into guestbook_admin values('abc',encrypt('hello'));So I tried to retrieve encrypted password using: - select * from guestbook_admin where unencrypt_function(password)= 'hello';
- select * from guestbook_admin where unencrypt(password)= 'hello';
- select * from guestbook_admin where deencrypt(password)= 'hello';
- select * from guestbook_admin where decrypt(password)= 'hello';
Also this page doesnt have any function which does reverse of encryptionhttp://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encrypt |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-08 : 20:01:40
|
Why are you posting MySQL questions on a Microsoft SQL Server forum?CODO ERGO SUM |
|
|
nasreen_laghari
Starting Member
3 Posts |
Posted - 2008-01-09 : 05:59:24
|
Ohhh Sorry I didnt realise that i'm not wrong forum. I have uploaded to MySQL AB now.Thank you |
|
|
|
|
|