Many of us face the issue of forgot password of joomla administrator. The password cannot be reset suing the 'Forgot password' link on front-end of website. We need to reset it from database. I am listing here 3 methods to reset or recover joomla admin password.
Method I :- Using simple update SQL query.
Step 1 - Navigate to phpMyAdmin and select the database of the joomla wesbite.
Step 2 - Click SQL at top and run the following SQL query
UPDATE `#__users` SET `password` = MD5('NEW_PASSWORD') WHERE `username` = "admin" ;
Where: '#_' is the table prefix
'NEW_PASSWORD' is the new password
Replace 'admin' with the username of you super user.
Method II :- Change password directly in the table.
Step 1 - Navigate to phpMyAdmin and select the database of the joomla wesbite.
Step 2 - Find and open the '#__users' table and then click on edit icon for the super user you want t o reset.
Step 3 - Select md5 from the function dropdown beside password field and add new passwor in the password field.
Method III :- Creating new Super administrator.
Step 1 - Navigate to phpMyAdmin and select the database of the joomla wesbite.
Step 2 - Click SQL tab at the top and run the following SQL query.
INSERT INTO `#__users` (`name`, `username`, `password`, `params`) VALUES ('Administrator2', 'admin2', 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `#__user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');
- This will create a new super admin user with username: admin2 and password: secret.
- Make sure to change the password as soon as you login to admin.