Do you need to reset password or Super User login?
Forgot your Joomla password? Locked out of your administrator backend? Need to reset the J! 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 super administrator login, there is a very easy way to reset the joomla admin password (admin) without requiring any particular extensions.
We have the complete and easy steps Use the steps below to reset your Joomla login details.
How to reset your Joomla password
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 web hosting details (such as our InMotion VPS). You will need to access the Users table in phpMyAdmin.
- On the left, you will see 2 links, click on your Database name
- 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.
- You will see all the table names are prefixed with some letters, e.g. adfa_
- The table names are on the right of the Underscore.
- Scroll down to the table xxxx_users, which is where the user credentials are stored and where we will reset the Joomla Administrator password
- Click on the ‘Browse‘ tab
- Click on the ‘Pencil‘ to edit your Super Administrator user.
- The next screen is where you can see the pass field and be able to change it
- Change the drop down to ‘MD5′ as seen below
- 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.
- 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.
- Go to your Administrator screen and try out the new login credentials you entered.
Forgot 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
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 the database!
The username is admin2 and the pass 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',
'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 User 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.
Looking for the 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 value to access any installation of the CMS.
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 J! installation, you can easily set a "Joomla default password". Follow the steps below to get access to your 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.
To reset the old user and pass:
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.
- 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.
- Click on the table "jos_users" in the list of tables.
- Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.
- Find the user whose details you want to change and press the Edit icon for this row.
- A form will display that allows you to edit the password field. Copy the value d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199into 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".
- 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 credentials 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', 'email@example.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 pass 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 secret key you have set it on the back end.
Reset v1.5 password
The procedure to reset a 1.5 login is not very different from the rest of the versions as described above.
- 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).
- Select the record for the administrator account - by default this is user 62.
- Copy and paste the following MD5 # and save the changes 21232f297a57a5a743894a0e4a801fc3
- Logon to the back end http://yoursitedomain.com/administrator using the credentials "admin" and the pass "admin" in the login box.
- 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.
- 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.
Reset v1.0 admin login
You need access to your MySQL database, via phpmyadmin or otherwise. For older J! versions up to 1.0.12 you need to execute the following query. The strange password is actually the encrypted version of the text "admin" with the encryption algorithm the CMS 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 pass, 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 pword 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 the CMS 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.
Please leave a useful comment with your thoughts, then share this on your Facebook group(s) who would find this useful and let's reap the benefits together. Thank you for sharing and being nice!