How to reset Joomla administrator password

Joomla’s administrator password can be changed with a simple MySQL query. Go to your cPanel and click on phpMyAdmin in the Databases box or access your MySQL database using the interface provided by your web hosting company.

We will consider that you have phpMyAdmin to manage your MySQL databases. In phpMyAdmin, select your Joomla database from the drop-down menu at left. The page will refresh and the database’s tables will be displayed at right side. Open the SQL tab (from 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` = “administrator” ;

“new_password” – replace this with the password you wish to set.
“administrator” – replace this if your admin username is different.

Once you are ready, click on the “GO” button to submit the query. If everything goes well, you should be able to login to Joomla with the new password.

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

If you have any questions related to Joomla, just ask your questions in our webmaster forum.

Leave a Reply