[rsuresh]

Hi all ,
Can we decrypt MYSQL password that was encrypted using password ( ) using PHP
Most of my clients need to know their old passwords ,

I tried in many places but i couldnt get any answers , Only way is to over write the existing passwords .

Please suggest a better function for encrypting and Decrypting passwords for MYSQL using PHP

Thanks in Advance
Suresh

[Rapid Dr3am]

Overwrite existing passwords.

The most common password encryption for php is md5 which is a one way hash.

[Worm]

Originally Posted by rsuresh

Hi all ,
Can we decrypt MYSQL password that was encrypted using password ( ) using PHP
Most of my clients need to know their old passwords ,

I tried in many places but i couldnt get any answers , Only way is to over write the existing passwords .

Please suggest a better function for encrypting and Decrypting passwords for MYSQL using PHP

Thanks in Advance
Suresh

Hi !

Afaics the MySQL password() function decrypts its input with a part of the password itself. That means that you cannot decrypt the password but only compare it with the encryption of a user input. This means furtheron that you can just select the password from the mysql table f.e. and compare it with the return value of password() with a given parameter. This is the way md5() and some other encryption algorithm works...