How to reset my Joomla 2.5 password?
If you have problems to access your Joomla 2.5 admin area and can not remember the correct password you can reset it directly from your database.
First, you should find which database your Joomla 2.5 installation uses. Detailed instructions are published in this article.
Then open your MySQL database management tool. The SiteGround clients can use phpMyAdmin available in their cPanel.
Load the tool and execute the following SQL query:
UPDATE `Your_Joomla_Database`.`Your_Joomla_Database_Prefixusers` SET `password` = MD5( 'New_Password' ) WHERE `sgj_users`.`username` ='Your_Joomla_Admin_Username';
In the above query you should 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.
Joomla is a powerful software that is easy to work with once you have the right host to support you. Before you lose any more time with the wrong host, check out the SiteGround Joomla hosting offer.