Resetting passwords

Management and Administration
#1

Is there a script that can reset passwords if locked out of the Admin userid?

#2

usually just run the following mysql command to reset admin to pass:

UPDATE users_secure SET `password` = '$2a$05$MKtnxYsfFPlb2mOW7Qzq2Oz61S26s5E80Yd60lKdX4Wy3PBdEufNu' WHERE `username` = 'admin'
#3

Hi Stephen,
Is there an update to this advice since the system no longer uses admin as a username

#4

hi @juggernautsei, you can replace the username value of admin with whatever the username actually is and it will then allow login with pass as password.

#5

@stephenwaite it did not work for me.

#6

ok, check the openemr log to see what the login error is then.

#7

The system has been taken offline so I can’t look at the error log. I will post here again once I have access again.

#8

i tried changing the password for my admin user but was still not able to log in.
(Turns out i think it’s because i’d marked my ‘admin’ user as active=0 a while back)

But what i ended up doing was
UPDATE globals SET gl_value = 0 WHERE gl_name = 'password_expiration_days';
to disable the password expiration, and then all users were able to log in again.