How to convert mysql PASSWORD() to md5()?

Question

I am creating a new database and my existing database already have some passwords that are sotred using MySQL PASSWORD() encryption, but in the new database i am using md5(). How do I convert the existing password to md5.

Thankyou.

Answer 1

hmm

encryption functions like 'md5()' etc, are made so it can't be decrypted..

i haven't tried decrypting passwords since they can't be decrypted..