MySQL and PHP guru's help needed
 

is there a piece of coding that will convert MySQL password() to PHP MD5() ? i have a database of users on one board and i need to move there account to a new one but the password encrytion is different.

is there a way to de-crypt MySQL passwoard() and then re-encrypt with PHP MD5() ?

In my experience there is no way to decrypt MySQL password function!

jDoG

From the MySQL manual... PASSWORD(str) Calculates a password string from the plaintext password str. This is the function that is used for encrypting MySQL passwords for storage in the Password column of the user grant table. mysql> select PASSWORD('badpwd'); -> '7f84554057dd964b' PASSWORD() encryption is non-reversible. PASSWORD() does not perform password encryption in the same way that Unix passwords are encrypted. You should not assume that if your Unix password and your MySQL password are the same, PASSWORD() will result in the same encrypted value as is stored in the Unix password file. See ENCRYPT(). If you could decrypt this, you might be able to decrypt user passwords from the mysql db.

OY. Never even considered this one. There *should* be a way but I've never seen anything. Have you checked out mysql.org to see if they have anything there? If/when you figure out how to decrypt you can basically do anything with them.

Another option - not exactly an eloquent one - would be to send out a bulk mail to all your members that autogenerates new passwords for them and they just have to confirm the email. Messy, yes, but it would also allow you to notify them that you're changing the board script so they can re-bookmark you. Just an idea - and for every problem facing humanity there is a simple and eloquent, and equally WRONG solution. :1orglaugh

hmm i think i found something http://www.php.net/manual/en/function.md5.php what do you think?

Just do it like that, this way you might also get some older inactive members to renew interest for your board. Sure, it´s not pretty, but if it works why spend time with encryption. You might even benefit from emailing everybody....

You can also tweak the code of the new board a little, so the hashing schemes are the same in both.