How to Reset Joomla admin password

Joomla is counted as an open source content management system called CMS with features and functions  to build Web sites and effective online applications. From different perspective including its ease of use, extensible and flexibility made Joomla the most popular Web site software and a content management system still available. Joomla is an open source solution that is any one can use it easily and it is freely available to everyone. For publishing content on the World Wide Web and intranets Joomla has perfect features to stand among all other CMSs.

The best thing about Joomla is it is written in PHP with object-oriented programming support and  techniques with MySQL database support. Now lets see how to Joomla admin password,

To reset admin password you need to make a change in to simple MySQL query. phpMyAdmin tool is the most convenient way to mange tables of a database. Go to your cPanel hosting account and click on phpMyAdmin in the Databases and run the query directly for Joomla’s database.

From the Drop down menu select the Joomla database of phpMyAdmin from the left. The page will refresh and the database’s tables will be displayed on it. Open the SQLtab (look at the top navigation bar).

Please write the following SQL query in the text field:

UPDATE `Table Name` SET `password` = MD5( ‘new_password’ ) WHERE `Table Name`.`username` = “admin” ;

“new_password”- Enter the new password you wish to use.
“admin”- Please replace this if your admin username is different.

Please click on Go button to submit the query. Now, you should be able to login to Joomla with the new password.