Modify admin password on Magento Enterprise Edition directly on the database

I've updated a Magento community site to a Magento Enterprise Edition. My pr开发者_高级运维oblem is that I can't login on the backoffice anymore. Magento EE uses a different password encryption so the old admin password doesn't work. The only way to change it is using a mysql query, but I don't know what's the encryption type. All tutorials I've found focus only on Magento Community.

Thanks for your help.

Pau

---

Put this as the very bottom of your index.php file and you will see the hash to insert into the database:

    Zend_Debug::dump(Mage::helper('core')->getHash('password', 2));

---

In your DB, search the admin_user table. search the row by your username and edit it and make a new passwd and choise the MD5 encryption