If due to some reason you have forgotten to your Joomla admin password and you are not able to login with your Joomla admin user. This tutorial will help you to check the active user and reset the admin password using MySQL query.
In this article I will show you how you can reset your Joomla Admin password using below methods.
Method #1 : Reset Joomla Admin Password Using MySQL Query
First of all, check the ID of the Joomla Administrator account using below command. You have to change the table prefix im4p8_ with your table prefix of Joomla database.
mysql> SELECT * FROM im4p8_users;
If you have only admin user account ID, now update the admin password using the below MySQL query. In this example your admin password will be “secret“, you can change it later from admin dashboard.
mysql > UPDATE im4p8_users set password = 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199' WHERE ID = 888;
Method #2 : Reset Joomla Admin Password Using phpMyAdmin
You can also reset your Joomla admin password via phpMyAdmin. Open table *_users and edit the record of the admin user and under the password column insert the below string and save the record by clicking Go button.
Now your password successfully rested and your new password is “secret“. You can change it later from admin dashboard.
Follow the below link to install and configure phpMyAdmin.