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. 

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 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 see the pass 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 Administrator screen and try out the new login credentials you entered.change super administrator password field

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

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 website. 21,000 users get our awesome 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 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',
    '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 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.

Forgot password function on the backend login

 

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. 

J! 1.6 

 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.

  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 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', '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 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.

  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 credentials  "admin" and the pass "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.

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.

One more thing... Did you know that people who share useful stuff like this post look AWESOME too? ;-)
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!

Featured On

Inc Magazine Logo  

Sitepoint logo  

CSS Tricks logo   

webdesignerdepot logo   WPMU DEV logo   

and many more!

Where are we hosted?

This site is proudly powered by FAST VPS InMotion Servers and given an insane speed thanks to MaxCDN!

Web Hosting MaxCDN - Speed up your website

New! DIVI 3.1 WordPress Template + PageBuilder

You'll surely create a perfect website with Divi 3.1!

Get an exclusive 10% OFF for CollectiveRay visitors until

Divi 3

 

WordPress Elementor Sale

Themes for the most popular WordPress page builder from TemplateMonster!

We've got an exclusive 10% OFF for CollectiveRay visitor until - use Coupon Code: collectiveray

TemplateMonster Elementor sale

 

TemplateMonster Bundles

Awesome bundles for awesome websites. $1300 worth of products for $49 only!

We've got an exclusive 10% OFF for CollectiveRay visitors until - use Coupon Code: collectiveray

TemplateMonster Bundles

How to make your website FAST!

Step-by-step - free email course, how to make your website load in less than 1 second 

The Outstanding HungryJPEG Bundles

AWESOMENESS! Bundles of premium font + graphic packs at more than 96% OFF!  Get a bundle for just $9 - ONLY!

The Hungry JPEG Awesome font bundles

 

Advertise on CollectiveRay.com

CollectiveRay (formerly known as DART Creations) is interested in developing partnerships with mutual benefit. If you like the stuff we publish and would like to develop a relationship, we'd be happy to hear from you. Go on - drop us a line - we'd love to hear from you :-)

 

 

Disclosure: CollectiveRay is funded personally out of pure passion for helping people working with websites. We do however generate some income through recommendations of products. This means if you click on a link and purchase an item we link to, we will receive a small sum out of that sale. We usually partner with vendors to make your purchase cheaper than buying direct.

Popular Content

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?

who are we?

CollectiveRay is run by David Attard - working in and around the web design niche for more than 12 years, we provide actionable tips for people who work with and on websites. We also run DronesBuy.net - a website for drone hobbyists.

David attard

Follow us on Social

Follow us on Facebook   Follow us on Google+   Subscribe to our RSS Feed   Follow us on Twitter