Lost password for Coppermine Photo Gallery v1.4.2

[zog]

Hi,

I installed Coppermine Photo Gallery v1.4.2 on my hosted server some years ago and decided to update this with new pictures, but I have forgotten the admin password or email address I used to set it up with.  I have access to the mysql dB that it runs on.

Is there any way I can reset or get the password back?

Regards, z.

[Aditya Mooley]

You can see your password from database table PREFIX_users directly if it is not stored in an encrypted format.
If its encrypted, edit the record and set password to e10adc3949ba59abbe56e057f20f883e (encrypted string for 123456).
Now login as admin to your gallery and reset the password immediately.

[zog]

Thank-you very much for the answer.

[Nibbler]

Also update your gallery.