How to reset my Joomla administrator password?

Joomla's admin username 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 cPanel and click on phpMyAdmin in the Databases box. (If you are not using cPanel or do not have phpMyAdmin, you can run the query directly for Joomla's database.)

Once in the phpMyAdmin select the Joomla 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:

"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.

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

If you have problems resetting the password yourself, ask your host for assistance. SiteGround provides the best Joomla hosting and such requests are handled with ease.

Joomla is a powerful software that is easy to work with once you have the right host to support you. Before you lose any more time with the wrong host, check out the SiteGround Joomla hosting offer.

2 Comments

  1. Reply March 8, 2017 / 04:00 RicardoSiteGround Team

    I am unable to reset the admin login info. please help

    • Reply March 8, 2017 / 13:24 Ivan AtanasovSiteGround Team

      The article shows an example of the SQL query which you can run. This is in terms of the users table.
      Your Joomla database tables could be with a prefix different from jos_ and you can confirm this from your cPanel -> phpMyAdmin.

      If your website is hosted here, we will gladly assist with the Joomla administrator password reset if you create a new Support Ticket from your User Area -> Support.

* (Required)