encrypt/decrypt

[Anon]

Yo!

Realise that it may be a stupid/old/boring question but in PHP manual couldn't find anything clearly described: when using username/password stored in mysql database I want them to be crypted there and decrypted when queried.
Some good way, anybody?

Bye

[dstockto]

Sorry, but the encryption used for storing the mysql passwords is one way only. There is no known way to get the original password out of the database when it is stored this way.

The reason that logging in still works is that the password you supply is encrypted with the same algorithm and the encrypted version is compared with what is stored in the database. Unfortunately, or maybe fortunately though, there is no way to go directly from an encrypted MySQL password to the original password.

Dave

[jdaniel]

You can use the mcrypt functions, however you still have the challenge of keeping your private keys protected.

• Jonathan