How to Reset Admin Password for Joomla

Forgot the password for Joomla login ?  Don’t worry, we can reset the password with the below steps :

# First we need to know which database is used for Joomla.
So check the configuration.php  file to get database details.
It is located at the root directory of your Joomla installation, usually under  /public_html/ folder.

public $db = 'mysite_joomla';
public $dbprefix = 'jos_';

# Now login to cPanel server with root user and enter below commands

mysql
use mysite_joomla;
select * from jos_users;
UPDATE 'jos_users' SET 'password' = MD5( 'new_password' ) WHERE 'jos_users'.'username' = “admin” ;

Note : Replace “new_password” with your new joomla admin user password.

Now you can test the joomla password by logging into the Joomla administrator interface from: www.mywebsite.com/administrator .