How to reset Joomla password via Database

Have you forgotten your password and you cannot access it through your Joomla Administrator Panel? If you can access the C-panel or the database in your localhost, then you can be able to change the password. This could be as a result of a forgotten password or a colleague changed it. If that is the case, then you have come to the right place. It is very easy to change the password of Joomla account via the database.

The following steps as described by Joomla page will show you how to do it.

  1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Find and click on the table with “_users” appended in the list of tables (note: you may have a prefix that is not jos_, simply go to the _users table for your prefix).
  3. Click on the “Browse” button in the top toolbar. This will show all of the users that are set up for this site.
  4. Find the user whose password you want to change and press the Edit icon for this row.
  5. A form will display that allows you to edit the password field. Copy the value
  1. d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

into the password field and press the Go button. phpMyAdmin should display the message “Affected rows: 1”. At this point, the password should be changed to “secret”.

  1. Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

After this, you will be able to access your administrator backend.

Leave a Reply

Your email address will not be published. Required fields are marked *

Translate »