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