Change of admin password

Tested on Magento 1.8.1

Data about admin are stored in table admin_user. Find required user (admin for example) and column named password. This column contains password hash in form <MD5 hash>:<suffix> – for example e53f3a2b9372babb593ed61c119c5ee1:El for string El123123q (password 123123q). Last 2 characters after : are substantially salt.

A new password (adminpassword for example) for user admin you can create with this SQL command:

UPDATE admin_user SET password = CONCAT(MD5('Eladminpassword'),':El') WHERE username = 'admin';

El you can replace with any string of course.

Resource

• http://www.magentocommerce.com/…min-password
• http://www.cutehits.com/…-in-magento/
• http://stackoverflow.com/…min-password