Magento Resources

How to change admin password using database in Magento ?

Posted on

Magento 1.9 and older :: The following statement into the SQL query text box. Replace NewPassword with the new password, and replace both occurrences of xx with any random two-character sequence: UPDATE admin_user SET password = CONCAT(MD5(‘xxNewPassword’), ‘:xx’) WHERE username = ‘admin’; Note:: This command assumes that you want to change the password for the […]