Please how can a forgotten openemr 5.0.1(7) password be retrieved or reset.
An admin password? Are you able to log in with another account or are you completely locked out?
Thanks for your response. I am completely logged out. No other account has been created yet apart from the admin account.
If you have your db access please execute below command on your OpenEMR database
update users_secure set password = ‘$2a$05$MKtnxYsfFPlb2mOW7Qzq2Oz61S26s5E80Yd60lKdX4Wy3PBdEufNu’ , salt = ‘$2a$05$MKtnxYsfFPlb2mOW7Qzq2b$’ where username = ‘admin’;
once this query got executed successfully your password will be the ‘pass’ for the admin user.
How did you install OpenEMR. Are you using xampp?
Thanks Nilesh. I will try it out and revert
I recently upgraded new 7.0 but forgot my admin password. I am running an application inside the docker in AWS lightsail. I tried your code, but it does not work. What is ‘salt’. it is not in the database. Thank you!
salt is for older versions
UPDATE users_secure SET `password` = '$2a$05$MKtnxYsfFPlb2mOW7Qzq2Oz61S26s5E80Yd60lKdX4Wy3PBdEufNu' WHERE `username` = 'admin';