I'm encrypting the passwords from users with the mysql function PASSWORD(), storing them in a table. Now i would like to "decrypt" this again using PHP. I read on the mysql-site that this function is non-reversible, but is there any PHP-function which can do the job??
Nope.
You should encrypt with PHP and decrypt with PHP.
There is no UN-PASSWORD() for mysql.
Use MD5 with multiple keys depending on your required security.
That is, unless you are doing some super top secret stuff.
why wouldn't you just encrypt the user-supplied password and compare the two encrypted versions for equality?
It's a long story, but to make it sort we want to move our customers from one ISP to another one. When moving them the users have to sign up for a new contract, and we want to extract as much info from what we got and push this into the signup-page for the new ISP....including theyr passwords, but i need to decrypt it to store it in the right format in the new DB.
So there is no way of decrypting the password encrypted with the mysql PASSWORD()function??
