If you have forgotten your #Joomla super admin password, or are helping someone who has forgotten their own password for their Joomla site, you can easily type a new one right into the user table in the Joomla SQL database (with one little "hack"). How to change lost or forgotten Joomla passwords right in the Joomla database is what today's #maintenancemonday is all about.
00:00 – Introduction: Resetting Super User Password, Giveaway & Joomla 3 Book
03:50 – Accessing Joomla Database via phpMyAdmin & Configuration.php Edits
05:44 – Resetting Super User Password Using Database & MD5 Encryption
10:00 – Backup Reminder Before Making Database Changes
10:34 – Final Thoughts on Password Reset & Live Chat with Mary
12:19 – Troubleshooting Joomla Password Reset with RS Firewall
14:52 – Banner Module Challenges & Searchability Issues
15:58 – Server Migration Challenges & XML-RPC Errors
20:37 – Wrapping Up & Final Goodbyes
Summary
Introduction & Welcome
Tim Davis welcomes viewers to Maintenance Monday #32, thanks new subscribers, and encourages likes and subscriptions.
Topic Introduction
Revisiting Joomla password recovery, showcasing a method shared by John Mulholt on resetting a lost super user password via the database.
Giveaway Announcement
Monthly giveaway update: Joomla 3 Explained book added to prizes alongside MyJoomla.com subscription and Regular Labs extensions.
Accessing the Database
Steps to access the Joomla database using phpMyAdmin via the hosting control panel.
Finding the Correct Database
Locate the database name in the configuration.php file to ensure you’re editing the right one.
Resetting the Password in phpMyAdmin
Open the #users table.
Select the user, click "Edit".
Choose MD5, type a new password, and save changes.
Logging in with the New Password
Demonstration of logging into Joomla with the newly set password.
Updating the Password in Joomla
Changing the temporary password to a stronger one via Joomla's backend user manager.
Caution & Backup Reminder
Importance of backing up Joomla before making database changes; alternative methods for those uncomfortable with phpMyAdmin.
Live Chat & Additional Insights
Discussion on security tools like RS Firewall preventing password changes, Joomla search issues, and potential differences between RS Firewall and Admin Tools.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment