Page 1 of 1

*SOLVED* Reset admin password from database

Posted: 24 Jul 2017, 11:06
by rezizter
I have taken over an existing install of opencats, however I don't have the username and password.

it is not the usual admin or cats password:

select * from user; shows me there is an admin user but the password field is encrypted.
How do I reset the admin password?

Re: Reset admin password from database

Posted: 24 Jul 2017, 12:41
by cptr13
I actually just worked through this and am writing it up for the documentation. Give me a few minutes to post a quick howto

Re: Reset admin password from database

Posted: 24 Jul 2017, 13:03
by cptr13
Resetting in PhpMyAdmin

If you have lost your admin password and you can't log in, then you're able to reset the password in your PhpMyAdmin. Complete the following steps:

Select your database in PhpMyAdmin

Select the prefixofyourtable_users table.

Click "Browse" and select "Edit" (the small pen icon) on the user whose password you wish to reset

You will now see all user data in a form. Under the "password" field, you will see a long list of encrypted letters. Delete these letters, and type in a new password.

BEFORE saving, remember to select "MD5" in the "function" dropdown list.

Save your new password and log into the backend of your Opencats site.

Re: Reset admin password from database

Posted: 24 Jul 2017, 13:07
by rezizter
Thank you soo much, works very well