Skip to content
PowerUser Guide
PowerUser Guide
  • Home
  • About
  • Topics
    • OS & Software
    • Software & Tools
    • Web Development
    • Other
    • Opinion
    • News
  • Reviews
  • Videos
  • Newsletter
  • Support Us
  • Contact
    • Request a Review

How to: Change Joomla’s super admin password

/ Geen categorie / By Steven Zeegers / 1 February 2010 1 February 2010

 

crappycrap

It’s scenario time again .  Just today, I was given the task to aid someone with his Joomla website.  The challenge:  The previous webmaster was being fired.  One of these reasons was that he made a total mess of the password administation (And he was working for other “customers” during work hours.  And, he’s quite incompetent; but that was not a reason for my customer to fire him). 

To make a long, complicated story short:  I needed a Super Admin password, and there was no option to get it from anyone.  So, I had to mess around in the database. 

Here’s the tale of how I changed the password of the Super Admin.

1.  First of all, I registered an account for myself. 

2.  Second of all, I logged on to the mysql server; and went to the table jos_users (jos might be something else in your case). 

3.  I looked up my user; and edited the record.  I then copied my hashed password.

4.  I looked up the Super Administrator account, and edited it.  I replaced his hashed password with mine, and saved the change.

5.  That’s all there is to it.  I could now log in as the Super Administrator, using my password. 

Alternative solution: [With thanks to this blog post]:    If you can’t register a new account (it happens more than you think); and / or aren’t afraid of executing a SQL command, try this alternative:

1.  Again, log in to the mysql server. 

2.  Select the database (if necessary) and execute the following SQL statement:

UPDATE `jos_users` SET `password` = MD5( ‘new password’ ) WHERE `jos_users`.`username` = "admin";

Obviously, you’ll want to replace new password with what you actually want to use as your new password. 

Post navigation
← Previous Post
Next Post →

Subscribe to get (e-mail) updates with our latest content

Join 1,556 other subscribers.

Recent Posts

  • How to expand the disk of your Hyper-V Quick Create Ubuntu
  • Moodle Quiz feedback in the wrong language?
  • Women should not read this post (or post)
  • Dark side of the “worst security audit ever”
  • Is Joomla relevant in 2022?

Recent Comments

  • Johnny on Elementor header and footer not displaying correctly?
  • Steven Zeegers on Elementor header and footer not displaying correctly?
  • hello1234567809 on Elementor header and footer not displaying correctly?
  • Steven Zeegers on Elementor header and footer not displaying correctly?
  • Dawg on Elementor header and footer not displaying correctly?

The Vault

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

About Us

  • About PowerUserGuide.com
  • About me
  • Support Us
  • Sponsors Page

Contact

  • Facebook
  • Youtube
  • Twitter
  • Subscribe to our newsletter

Copyright © 2023 PowerUser Guide | A Sigiharja Website
Cookies op deze website
Deze website maakt gebruik van cookies om de gebruikservaring te verbeteren.
Door deze website te gebruiken geef je aan dat je hiervan op de hoogte bent en akkoord gaat met onze Privacy Statement.Akkoord Lees Meer
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT