I have been locked out of my dashboard for over a week now, the error message says in correct details. i have reset my password, but this has not worked.

any advice.

  • please specify your Magento version – Divyesh May 22 '18 at 13:28
  • Check my answer it will help you if you are using Magento 2 version. – Nikunj Vadariya May 22 '18 at 13:35
  • if my answer solves your concern then there is green right tick mark, hit that tickmark for right answer that will help future readers. – Nikunj Vadariya May 22 '18 at 13:40
  • Hello not Magento 2... – Kate Walker May 22 '18 at 13:55
  • @KateWalker, if none of the answers help you, please specify your Magento version in your question. – Mohit Kumar Arora May 23 '18 at 9:33

You'll need direct database access to reset the admin password.

If you are having troubles and want to reset it to a different password, just run at your sql database:

SELECT * FROM admin_user;

Then, find the username you want to modify in the listing provided - ‘admin’ in this example. Then, to update the password, type:

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

‘qX’ would be changed to whatever you want it to be and same goes for ‘password’

You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.

If you want to add a new admin user, you must not only create a new entry in the table ‘admin_user’, but you also have to insert an entry in the table ‘admin_role’ which has to be associated with the user by the field ‘user_id’.

Source - https://magento2.atlassian.net/wiki/plugins/servlet/mobile?contentId=14024839#content/view/14024839


If you are using Magento 2 then here is a solution.

Here is how you can unlock and Go to your Magento root folder SSH.

Then Run the following command

php bin/magento admin:user:unlock ADMINUSERNAME

Or jump into bin directory from Magento root: cd bin/

and then run a command

php bin/magento admin:user:unlock ADMINUSERNAME

For more detail visit magento official doc.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.