1

I have many admin users in my magento backend. I want to know one particular user's password, but password stored like below image. enter image description here

How to know that user's password without reset password.

Is there any way in magento.?

3
  • posting here may help : dba.stackexchange.com Feb 8 '18 at 12:22
  • Okay. but i don't know that is it database related or magento related. Feb 8 '18 at 12:31
  • 1
    simply, you can't , it is encrypted with md5 , which is not reversible, you can use @mohit kumar arora answer to reset the password ;) Feb 8 '18 at 15:03
2

Magento, by default, saves the password in CONCAT(MD5('qXyourpassword'),':qX') format, where 'qX' is salt value for encryption and it can be any other string and the string 'yourpassword' can be replaced by the user's password.

If by any chance, the string qX is blank, then you can try decoding the password using MD5 decode online tools. But in most cases, it is not possible that the salt value for encryption is empty.

That is why Magento is too secure.

If you want to change the password, you can try the following query:

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

where 'USERNAME' is the desired username for which you want to reset the password.

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.