If you have forgotten the password for the backend of a CMS, there is no need to panic — all is not lost. You can reset the password by making a change directly in the database.
Here is how you can do this:
First, you need to open phpMyAdmin.
For local installations on localhost, you can simply enter
localhost/phpMyAdmin
in your browser.
If your website is already online, you need to log in to your server's administration software instead. In our example, we use Plesk.
Once you are logged in, go to the menu item
Domains
and look for your project. After selecting your project, a new menu will open where you can access the required database under Databases. phpMyAdmin will then open and display your database entries.
Look for the table:
s_core_auth
and open it.
You should now see a list of all registered users. Find your account and click Edit.
Important: The password displayed here is not your actual password, but an encrypted version of it. This means that you cannot simply copy the password and use it elsewhere.
To create a new password, double-click the encrypted old password and overwrite it. Next, select an encoder (ideally, use the same encoder as the other users) so that your password is encrypted again, and save your changes.
You should now be able to log in to the backend again.
