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