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.

  • 318 Users Found This Useful

Was this answer helpful?

Related Articles

How do I reset Zen Cart administrator password?

First login to your control panel with us, then click on the "phpMyAdmin" icon. Click the...

Best WP Plugins

The best wp plugins we believe at this time are W3Total Cache, WordFence, Yoast SEO and iThemes...

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

Joomla Warning: Parameter 2 to frontpage()

The error: Joomla Warning: Parameter 2 to frontpage() can occur when you use an out-dated install...

How do I reset Mambo administrator password?

To reset the password for mambo's admin page simply access the MySQL database by logging into...