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

 

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,663 other subscribers.

Recent Posts

  • How to add domains to your Mac hostfile
  • Write a python script to check the status of your websites
  • How to filter phishing campaigns like phished.io
  • This is why you need MFA
  • How to expand the disk of your Hyper-V Quick Create Ubuntu

Recent Comments

  • Eric on How to expand the disk of your Hyper-V Quick Create Ubuntu
  • Steven Zeegers on Elementor header and footer not displaying correctly?
  • flowersbycenterpiece on Elementor header and footer not displaying correctly?
  • Johnny on Elementor header and footer not displaying correctly?
  • Steven Zeegers 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 on this website
This website uses cookies to improve your user experience. It also uses cookies to collect analytics to make the website even better for you in the future. Akkoord Read more
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