Admin Password Problem

[DarkSide]

Due to me being forgetful I have forgotten the original admin password (d`oh).

I have used the reset password function and the mail is recieved without a problem but the recieved password does not work! Is there any way I can manually set the password or even make my (only) reseller account the admin so I can remove the original admin account?

All help gratefully recieved, I am stuck.

[sci2tech]

In database ispcp, table admin replace field admin_pass with an md5 of your new password