This article describes how to reset the Magento administrator password.
Normally if you forget your password, you can use the Magento password recovery feature to reset the password by e-mail. However, if this option is unavailable (for example, if e-mail on your site is not working correctly), you can use phpMyAdmin to manually reset the password in the database.
The quickest and easiest way to reset the Magento administrator password is to request a new one through e-mail. To do this, follow these steps:
You can also modify the Magento administrator password directly in the database using phpMyAdmin. To do this, follow the appropriate procedure for your version of Magento.
To reset the administrator password directly in the Magento 2 database, follow these steps:
UPDATE admin_user SET `password` = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE `username` = 'admin';
UPDATE mg_admin_user SET `password` = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE `username` = 'admin';
To reset the administrator password directly in Magento 1.9 and older versions, follow these steps:
UPDATE admin_user SET `password` = CONCAT(MD5('xxNewPassword'), ':xx') WHERE `username` = 'admin';
UPDATE mg_admin_user SET `password` = CONCAT(MD5('xxNewPassword'), ':xx') WHERE `username` = 'admin';
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
Usamos cookies con el fin de personalizar para usted nuestro sitio Web y analizar el uso de éste. Usted acepta esto haciendo clic en “Acepto” o al continuar usando el sitio Web. Hay más información sobre cookies en nuestra política de privacidad.