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

How to turn off magic quotes gpc for Joomla 3

Add the line "php_flag magic_quotes_gpc off" to the .htaccess file. If one does not exist create...

Joomla Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with that of JRegistry::loadSetupFile()

For this particular error we have found a work around which works until Joomla corrects their...

PHPList Email Throttling

As we are primarily a website hosting provider we limit email sending to 150 emails per hour. If...

osCommerce - This is a potential security risk - please set the right user permissions on this file.

This error is caused when the /includes/configure.php is world writable. To correct this, log...

Gallery2 thumbnails will not show

If you are able to view your pictures in Gallery2 but the thumbnails are not showing or are...