[ELV1I2]

Hi. Due to security reason I thought to write down into table passwords of user using MD5 or SHA-1 function for encryption. I'm not sure how these routine really working and have fear that once, in future, if I for example export whole DB to CD and on other computer install new MySQL DB and then import saved data of former DB, will it be "readable", including fields made using MD5? I presume that it shall working but never tried. Someone told me that each new installation of MySQL make some unique key that is used for generation data when MD5 or SHA-1 encryption is involved..? Is it true or not? Thank you.

[mab]

MD5/SHA are one-way hashes. Once something has been passed through a one-way hash, the original value is not present (unless you kept and stored the original value yourself.)

Exporting the database won't show the original values.

The following is incorrect -

Someone told me that each new installation of MySQL make some unique key that is used for generation data when MD5 or SHA-1 encryption is involved..?

MD5/SHA are algorithms. They don't use a unique key for anything.

[ELV1I2]

Thanks a lot man, I feel now much better!