So I have recently converted a UBB.threads board to PHPBB2 which I was admin on. Here's the problem, the old admin and admin account on the UBB forum is gone/inactive, yet their account is the only current admin account on the PHPBB2 board now since the conversion, my account got removed and now I do not have admin access.

How can I retrieve the ADMIN password from the new PHPBB database. I have their username available. Alternatively, how can I set my own account back to admin status by editing the database? This is my only solution atm. I am in the mySql admin and am able to directly edit/browse the db.