decrypt password()

Anon

Hi,

I wanted to test the password() function in mysql and so update in a temporary database with this query -
update user set password = password(password)

This encrypted all the passwords for all users.

Now i want to decrypt these passwords. That is i want password "karthik" to be stored as "karthik" and NOT as "092jduu223213s".

How do i do this ?

Thanks,
Karthik.

crazzykid

easy.. dont use password(karthik) to store passwords just set "karthik" if you put password(watever) then it will encrypt it..
there is no decrypt function else wats the point of encrypting something? you have to do some command (cant remember) to compare a text password with a encrypted one =)

hope that helps you

Anon

Hi,

I know that... but the thing is i have changed the database values already with the encrypted values... i want to revert back to the original unecncrypted values....

Is that possible ?

Thanks,
Karthik

badman

sorry pal, the password() function is one way ticket!

it cant be undone, but you can still use them by encrypting the supplied password using the same function ie "select password'karthik')";

and then checking against entry in database.

hope you get it.

Anon

Hi,

I have done that already.

Sad to know that its a one-way process... thought there would be some way to undo it.

Thanks anyway,
Karthik.

mrobben

It's not sad at all that this is a one-way function. Otherwise everyone could read these encrypted passwords!

You would have been able to undo this if you had a backup of your DB

Regards,
Maarten

Anon

Hi,
I didnt mean sad in that manner... and dont worry i do have a DB backup. I had assumed that there would be some means of undoing the encryption by the administrator or the user who issued the command.

Thats why i had asked .... anyway thanks to everybody for all the help.

Karthik.