Magento 1.x – Create a new backend admin user from database

If you need to create a new backend admin user, you can use the following database script:

Instead, if you just need to change the password of an existing user, you can do the following:


Then remember to clean cache and try to access with your new user.


Note: if you are being redirected to the same login page, take care of your web/cookie/cookie_domain value in the core_config_data table.