jophefs in A friend called me an hour ago and ask to help him with his Joomla site, I ask him what help he need. He said “I forgot my Administrator password!” So I wrote this simple tutorial on how to reset or to change Joomla administrator password.
You can change your Joomla administrator password easily using a simple MySQL query. the best way to manage the database is through the phpMyAdmin tool. Go to your cPanel and click on phpMyAdmin in the Databases box. (If you are not using cPanel or do not have phpMyAdmin, you can run the query directly for Joomla’s database.)
In the phpMyAdmin select the Joomla’s database from the drop-down menu at left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab at the top navigation as shown in the image below
In the text field write the following SQL query:
UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;
“new_password” - replace this with the new password you wish to use.
“admin” - replace this if your admin username is different.
whwn you have change your password click on the GO button to submit the query. If everything goes fine without errors, you will be able to login to your Joomla using the new password.
