Linux Administrator

How to Reset Joomla Admin Password Using MySQL or phpMyAdmin

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.

Thank you! for visiting LookLinux.

If you find this tutorial helpful please share with your friends to keep it alive. For more helpful topic browse my website To become an author at Look Linux Submit Article. Stay connected to Facebook.

About the author


Santosh Prasad

Hi! I'm Santosh and I'm here to post some cool article for you. If you have any query and suggestion please comment in comment section.

Leave a Comment