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.