If you have lost your super user password for logging into Joomla, you cannot reset it using the core Joomla lost password feature. You will have to go into your database and put a temporary password in for your account in order to log in and change reset your password. That is what today's #maintenancemonday is all about.
00:00 – Introduction
01:45 – Problem Overview
02:53 – Giveaway Announcement
03:35 – Accessing the Database
04:54 – Finding the User Table
05:35 – Understanding Password Hashing
06:46 – Replacing the Password Hash
08:08 – Logging In with the New Password
08:52 – Changing the Password Securely
09:41 – Conclusion
Summary
Introduction and Context
Tim Davis introduces the livestream, mentioning it’s almost not Monday in most parts of the world. He shares a personal anecdote about his wife being away and his struggles with household tasks.
Topic Introduction: Resetting Super Admin Password
Tim explains the issue of forgetting the super admin password for a Joomla site and introduces the topic of resetting it. He mentions that the core Joomla password reminder tool doesn’t work for super admin accounts.
Accessing the Database via cPanel
Tim demonstrates how to access the Joomla database using cPanel and PHPMyAdmin. He explains how to locate the correct database by checking the configuration.php file.
Locating and Modifying the Password Hash
Tim shows how to find the users table in the database and locate the super admin password hash. He explains that the password is stored as an encrypted hash and demonstrates how to replace it with a known hash (e.g., for the password "secret").
Logging In and Resetting the Password
After replacing the hash, Tim logs into the Joomla backend using the temporary password "secret." He emphasizes the importance of immediately changing the password to something secure to prevent unauthorized access.
Conclusion and Call for Feedback
Tim wraps up the livestream, thanking viewers for their support and encouraging them to suggest topics for future Maintenance Monday episodes. He signs off with well-wishes for viewers to enjoy their Joomla sites.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment