Recovery of admin password OJS


One journal asked me to help them to recover their admin password. I entered users table edited password and choose MD5. After saving I cannot login in the system. Please advise.

Hi @vvucic,

I suspect you just passed the password through the MD5 MySQL function; that won’t work, as we prepend the username before creating the hash to help reduce the risk of dictionary attacks. See e.g. this thread for an example query to reset the password directly in the database. You’ll have to use either MD5 or SHA1 depending on your settings.

Alec Smecher
Public Knowledge Project Team

I checked their and it is SHA1 there.
I issued query and it worked successfully.