Our website developer has not provided us the main Admin ID and Password. so hardly after reading some posts now, I found the admin_user file in the database.

Please find attached screenshot and advice me can I change the Admin Password directly writing in the Password-Box?enter image description here

  • 1
    for magento 1 or Magento 2 ?
    – Yogesh
    Oct 14 '17 at 12:26
  • for magento 1 select md5 from dropdown menu
    – MagenX
    Oct 15 '17 at 8:16

You can try following sql query

UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxYourNewPassword', 256), ':xxxxxxx:1') WHERE username = 'admin';

Keep xxxxxxx as it is in the query.

Alternatively, you can try the command bin/magento admin:user:create

For more details on using this command go through https://devdocs.magento.com/guides/v2.2/install-gde/install/cli/install-cli-subcommands-admin.html

  • This is for M2 only, and dont forget to check the lock_expires field also if you've entered multiple wrong passwords already...
    – KolonUK
    Feb 12 '19 at 13:01

no, because the password is hashed.

You can update the password by clicking on sql in the top and executing the following sql command:

UPDATE admin_user SET `password` = md5('YOUR_NEW_PASSWORD'), is_active = 1 WHERE `username` = 'YOUR_ADMIN_USERNAME';

You should change your password in the Magento backend afterwards again.

  • he is already in phpmyadmin admin_user table , just use dropdown menu, select md5 and thats it. but it will work only for magento 1
    – MagenX
    Oct 15 '17 at 8:15

You can update the password by using Function of MD5 please check below image.

enter image description here

  • Nope. Doesn't work in M2 Oct 24 '18 at 13:00
  • More specifically, M2 requires SHA2, and requires a salt...
    – KolonUK
    Feb 12 '19 at 13:00

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.