Google Ads

Proudly Hosted on

About Me

Hi, I 'm Aditya, the guy behind this website and many other. This site acts as my web playground, where I share all about me, my work and my knowledge.

I have over 8 yrs hands on experience in PHP, Mysql, JavaScript, open sources CMS like Joomla, Wordpress etc. During these 8 years, I have worked on more than 200 projects and/or websites but could not spare time for my blog.

 

 

Recover or Reset Joomla admin password

joomla-admin

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.

edit-user

Step 3 – Select md5 from the function dropdown beside password field and add new passwor in the password field.

edit-user-pass

 

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.

SocialTwist Tell-a-Friend
Comments are closed.
Home / Recover or Reset Joomla admin password