Blog

A Blog by DotJoomla

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.

Recover or Reset Joomla admin password

Posted by on in Joomla
  • Font size: Larger Smaller
  • Hits: 3221
  • 0 Comments
  • Subscribe to this entry
  • Print

joomla adminMany 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.

Vijay Singh is a web Developer with vast experience in the field. Has developed hundreds of websites. He is also a hobbiest blogger. He writes blogs when he is free ( not usually though ).

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Monday, 25 September 2017

Blog Archive

Login Form

Who's Online

We have 57 guests and no members online