[How to] Reset the Joomla Admin Password if you forgot it

Do you need to reset Joomla password or Super User login?

Forgot your Joomla password? Locked out of your Joomla administrator? Need to reset the Joomla credentials?

This happened to us quite a few times before we learned to store the passwords in a safe place. However, if you do forget or lose your Joomla super administrator login, there is a very easy way to reset the joomla admin password (admin).

We have the complete and easy steps Use the steps below to reset your login details. 

Joomla reset admin password

Reset Joomla 2.5 / 3 admin password via phpmyadmin

You can reset the Joomla admin password if you have access to phpmyadmin. Browse to phpmyadmin using the credentials which you should have available as part of your joomla web hosting details (such as our InMotion VPS). You will need to access the Users table in phpMyAdmin 

  1. On the left, you will see 2 links, click on your Database name 
  2. Do not delete or change any of the tables if you do not know what you are doing. You can potentially corrupt your database, lose information or delete your whole database.
  3.  You will see all the table names are prefixed with some letters, e.g. adfa_
  4. The table names are on the right of the Underscore.
  5. Scroll down to the table  xxxx_users, which is where the user credentials are stored and where we will reset the Joomla Administrator password
  6. Click on the ‘Browse‘ tab
  7. Click on the ‘Pencil‘ to edit your Super Administrator user.
  8. The next screen is where you can the password field and be able to change it
  9. Change the drop down to ‘MD5′ as seen below
  10. Enter your new login details in the text box beside it - you can enter it in plain text, the new value will then be encoded by phpmyadmin. See the screenshot below of how your xxxx_users table should look like.  Then press Go to save.
  11. After that, your new credentials are in place.  You will see on the next screen that the password field changed to a bunch of letters and numbers that you didn’t enter.  That’s ok because that’s how MySQL stores your data.
  12. Go to your Joomla Administrator screen and try out the new login credentials you entered.change joomla super administrator password

Forgot Joomla Password video

If you prefer watching how these steps on a video, we've also replicated this article as a YouTube video, which you can watch below

Let's help you manage your Joomla better

joomla

Free Joomla tips ebook button

Hey there Joomlero!

We hope you were able to reset access to your Joomla installation. 21,000 users get our awesome Joomla tips for people like you. Want to join them?

 

Joomla extensions to take your website to the NEXT level

Is your Joomla website reaching its full potential? We install many of these extensions on almost ALL of our Joomla sites - why don't you check them out our list of Joomla Extensions and see whether you can take your site to the next level?

How to Create a new Joomla admin user

There could be many reasons why during some phase of your website design, you lose administrator access to your website. You might have forgotten the credentials of the administrator, or some other way got locked out of your backend. It is easy to create a new administrator user via phpmyadmin on the hosting service of your website.

The following is a command which will add a new user to the users table in Joomla!

The username is admin2 and the password is "secret" (no quotes).

You simply need to enter the following command in the cpanel of your hosting company via phpmyadmin for your hosting database. Once you enter the command below you can access the administrator backend. Don't forget to change the value from secret to something more secure to ensure your website doesn't get hacked!

INSERT INTO `jos_users`
   (`name`, `username`, `password`, `usertype`, `gid`, `params`)
VALUES ('Administrator2', 'admin2',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
    'Super Administrator', 25, '');
INSERT INTO `jos_core_acl_aro`
VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator2', 0);
INSERT INTO `jos_core_acl_groups_aro_map`
VALUES (25, '', LAST_INSERT_ID());

How to reset the Joomla Credentials (the easy way)

The above procedure is typically necessary if you don't have access to the email address associated with the administrator user.

But if you do have access, there is a very easy way to reset the credentials of the administrator.

The Joomla backend login screen actually has a "Forgot your Password?" function. This is not hidden, but we weren't actually aware of it, so we're throwing it out there, just in case you didn't know about it! 

Have a look at the screenshot below to see how to activate it.

Forgot Joomla password on the backend login

 

Looking for the Joomla default login or password?

The default Joomla login is "admin", however, you're out of luck if you are looking for a default password - so you won't be able to use a single password to access any Joomla installation.

However, if you have access to the hosting account (did you know that InMotion can reset your credentials if you forgot them?), the cpanel, or the phpmyadmin of the Joomla installation, you can easily set a "Joomla default password". Follow the steps below to get access to your Joomla administrator user if you have forgotten the login credentials. 

At CollectiveRay, we write web design blogs for webmaster and website users. Subscribe or follow our pages to stay updated. 

Joomla 1.6 

 To reset the old password: 

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin.

  1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Click on the table "jos_users" in the list of tables.
  3. Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.
  4. Find the user whose details you want to change and press the Edit icon for this row.
  5. A form will display that allows you to edit the password field. Copy the value
    d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
    into the password field and press the Go button. phpMyAdmin should display the message "Affected rows: 1". At this point, you have changed it to "secret".
  6. Log in to the backend with these new credentials, go to the Users screen, search for your admin user and change the credentials again to a more secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

 

To create a new admin2 user: 

Open the database using phpMyAdmin or database explorer and select the table, jos_users . (replace jos_ with your own table prefix if this is different than the default).

Run the following SQL Code:

INSERT INTO `jos_users`(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,`registerDate`, `lastvisitDate`,`activation`,`params`)

VALUES ('40', 'Administrator2', 'admin2', 'your-email@yourdomain.com','d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199','Super Administrator', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00',"","")

INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (40, 8)

Logon to the back end http://yoursitedomain.com/administrator  using the credentials admin2/secret in the login box.

Select the user you have just logged in and change the password for the user to something else. This is extremely important otherwise your website might get hacked.

Check all is ok with Front-end access by opening your site http://yourdomainname.com and logging in using the username admin and the new password you have set it in the back end.

Reset Joomla 1.5 password

The procedure to reset a Joomla 1.5 login is not very different from the rest of the versions of Joomla.

  1. Open the database using phpMyAdmin or database explorer and select the table, jos_users . (replace jos_ with your own table prefix if this is different than the default).
  2. Select the record for the administrator account - by default this is user 62. 
  3. Copy and paste the following MD5 # and save the changes 21232f297a57a5a743894a0e4a801fc3
  4. Logon to the back end http://yoursitedomain.com/administrator using the username admin and the password admin in the login box.
  5. Select the user you have just logged in with and change the password for the user to something else. This is extremely important otherwise your website might get hacked.
  6. Check all is ok with Front-end access by opening your site http://yourdomainname.com and logging in using the credentials you have set in the back end.

Joomla 1.0 

You need access to your MySQL database, via phpmyadmin or otherwise. For Joomla version up to 1.0.12 you need to execute the following query. The strange password is actually the password "admin" encrypted with the encyption algorithm Joomla uses.

UPDATE `jos_users` SET `name` = 'admin', `password` = '21232f297a57a5a743894a0e4a801fc3' WHERE `id` =62 LIMIT 1 ;

 

For 1.0.13, you need to run a query with a different value for the password, which is below because the encryption algorithm has changed.

 

UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ;

 

Once you've run this query you need to login to the administrator backend and set the password to something more complicated. Leaving it as "admin" will result in a serious risk to your site!

 

If you're running an older version of Joomla or Mambo, you might need to change jos_users to mos_users. 

These instructions are surely a great way to recover your Joomla password if you've forgotten it.

Want to supercharge your website?

 
  Our website loads FAST ... just 1.29 seconds. We're hosted on FAST InMotion VPS servers - click here to see our full review. We want YOUR website to be fast too, so we've gotten you an exclusive deal - 47% OFF for CollectiveRay visitors + FREE domain! Click the button below to grab a bargain. (This is a limited offer - so get it while it lasts)