1. Home
  2. Knowledge Base
  3. Applications
  4. Joomla
  5. How to reset admin password for Joomla 2.5 using phpmyadmin

How to reset admin password for Joomla 2.5 using phpmyadmin

Step 1: Login to cpanel

Step 2: Select phpmyadmin under Database

Step 3: 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.

Now the admin password will be changed.

Related Articles