How do I reset Joomla administrator password?

How to reset Joomla administrative password

Start by logging into your control panel. Once logged in, click on the "MySQL" icon. In the MySQL section click on "phpMyAdmin" at the bottom.

Once in phpMyAdmin you will select the Joomla's database from the menu on the left by clicking on its name. Click the SQL tab at the top navigation bar.

In the text field write the following SQL query:

UPDATE `jos_users` SET `password` = MD5( 'newpassword' ) WHERE `jos_users`.`username` = "myadmin" ;

"newpassword" - replace this with the new password you wish to use.
"myadmin" - 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.

These steps work with Joomla version 1.5 and Joomla version 1.0.


Share this page:


Was this article useful? Have any suggestions or improvements to the information?

Also Read

Turn off PHP error messages via .htaccess

From time to time you may encounter a script which has error messages you do not wish to see....

Moodle: Notice: Only variable references should be returned by reference

Notice: Only variable references should be returned by reference The issue is with Moodle...

phpBB: Switching template to default theme

To change your phpBB theme back to the default which may be necessary when upgrading, log into...

Tiki Wiki: Notice: Only variable references should be returned by reference

You can find the latest version of ADODB here. To modify the function to not return a...

Strict Standards Error in Joomla

You are running an out-dated install of Joomla and we highly recommend updating it to avoid your...