#25 - Forgot or need to reset Joomla admin password?

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

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

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 password if you forgot it?), the cpanel, or the phpmyadmin of the Joomla installation, you can easily set the current password to a "Joomla default password". Follow the steps below to get access to your Joomla administrator user if you have forgotten the password. 

Joomla: Reset the admin password 

Forgot Joomla 2.5 / 3.x password? - how to change it via phpmyadmin

You can reset the Joomla admin password if you have access to phpmyadmin. Browse to phpmyadmin using the database administrator and password which you should have available as part of your joomla web hosting details.

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
  • Click on the ‘Browse‘ tab

Reset the Joomla Administrator Password

  • Click on the ‘Pencil‘ to edit your Super Administrator user.
  • The next screen is where you can change your password, See the password field:
    • Change the password drop down to ‘MD5′
    • Enter in a new password in the text box beside it - you can enter it in plain text, the password will then be encoded by phpmyadmin
See the screenshot below of how your xxxx_users table should look like.  Then press Go.
change joomla super administrator password
 

After that your password is changed.  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 password.

Go to your Joomla Administrator screen and try out your new username and password you entered.

Let's help you manage your Joomla better

joomla

Free Joomla tips ebook button

Hey there Joomlero!

We hope you were able to recover your Joomla password. 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?

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 password 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, the password should be changed to "secret".
  6. Log in with this user and password and change the password of this user to a 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 username admin2 and the password secret in the login box.

Select the user you have just logged in with using this password and username 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.

Joomla 1.5


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 MD5 # below and save the changes

21232f297a57a5a743894a0e4a801fc3

5. Logon to the back end http://yoursitedomain.com/administrator using the username admin and the password admin in the login box.

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

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

  

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 logon to the administrator backed and set the password to something more complicated. Leaving the password 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.

One more thing...

Do you have friends or a Facebook group who you think would find this useful? Share this with them and then let me know what they think.

Want to supercharge your website?

  Our website loads FAST ... just 1.29 seconds. We're hosted on FAST InMotion servers We want YOUR website to be fast too, so we've gotten you an exclusive deal - 47% OFF for DART Creations friends + FREE domain! Check it out NOW!

Translate

who are we?

DART Creations 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

         

 

 

 

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?

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

 

InMotion Hosting Review - Recommended Web Hosting servers for business, Joomla, WordPress and ecommerce websites.

InMotion Hosting Review

Advertise on DART-Creations.com

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 :-)

The Outstanding october Bundle

30 premiums fonts, 11 graphic packs for$29. Get it NOW - October Only!

Outstanding October bundle

New! DIVI 3.0 WordPress TeMPLATE + PageBuilder - 10% OFF Limited Launch offer

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

Divi 3