Other Applications
How to reset my Joomla! 2.5 password?

How to reset my Joomla! 2.5 password?

If you cannot access your Joomla! 2.5 admin area and do not remember the correct password you can reset it directly from your database.

First, find which database your Joomla! 2.5 installation uses. Detailed instructions are published in this article.

Then go to your Site Tools > Site > MySQL > phpMyAdmin.

Once there, select your database from the menu on the left, go to SQL and execute the following SQL query:

UPDATE `Your_Joomla_Database`.`Your_Joomla_Database_Prefixusers` 
SET `password` = MD5( 'New_Password' ) WHERE `sgj_users`.`username` 

In the above query, replace Your_Joomla_Database with your actual Joomla! database name. Set your database prefix instead of Your_Joomla_Database_Prefix (for example if the prefix is ‘jos_‘ the table string will be ‘jos_users‘). Enter the new password and your Joomla! 2.5 admin username instead of the following strings: New_Password and Your_Joomla_Admin_Username.

Share This Article