How to reset my Joomla administrator password?

Joomla's admin password can be easily changed with a simple MySQL query. The most convenient way to manage the database is through the phpMyAdmin tool. Go to your control Panel and click on phpMyAdmin in the Databases box.

Once in the phpMyAdmin select the Joomla's database from the drop-down menu at left. The page will refresh and the database's tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;

"new_password" - replace this with the new password you wish to use.
"admin" - replace this if your admin username is different.



Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to Joomla with the new password.
 
Alternatively, it can be done with a few clicks as below:
 
  1. Login into your Hosting control panel
  2. Access to phpMyAdmin
  3. Locate Joomla database such as ( username_dbname )
  4. Select jos_users
  5. Locate the user 
  6. Click on the pencil on the left 
  7. Locate the password column 
  8. Key in the new password on the Value column on the right 
  9. Select Function as MD5
  10. Click on Go


Note: These instructions are valid both for Joomla 1.0 and Joomla 1.5.*.

Add Feedback