How to Create a New Joomla Super User When You Cannot Log In
If every usable Super User account is unavailable, the goal is to regain controlled Administrator access and create a normal replacement account—not to leave a public emergency credential in the database. On Joomla 6, avoid historical SQL examples that depend on obsolete password hashes.
If every usable Super User account is unavailable, restore controlled Administrator access first and create the replacement Super User inside Joomla. Avoid historical SQL examples that depend on obsolete password hashes or leave a known emergency credential behind.
Back up the site before recovery
Create a current backup of both Joomla files and the complete database. Confirm you are working on the correct installation and keep a record of every emergency change. Super User recovery changes the site's highest privilege level, so rollback must be possible.
Avoid old create-admin SQL examples
Do not use a legacy “admin / secret” style SQL recipe or a public password hash as a modern Joomla recovery method. Password storage and account recovery have changed across Joomla generations, and a known credential is especially inappropriate for a Super User.
Regain temporary privileged access
Follow the Administrator recovery procedure documented for the installed Joomla version. Where applicable, Joomla's documented temporary $root_user setting in configuration.php can elevate a known account long enough to repair normal access. Protect the configuration file while the temporary setting exists.
Create the replacement Super User inside Joomla
- Open Users → Manage and select New.
- Enter a unique name, Login Name, and valid email address.
- Set a unique strong password.
- Under Assigned User Groups, select Super Users only if unrestricted administration is genuinely required.
- Save the account.
Do not reuse a shared administrator identity when an individual account can be created.
Test before removing the recovery path
Open a separate private browser session and sign in to Administrator with the new account. Confirm it can perform the required Super User actions. Configure MFA as appropriate. Keep the temporary recovery path only until this normal account is proven.
Remove emergency access and investigate the lockout
Remove the temporary $root_user setting from configuration.php, restore appropriate file protection, and verify the new account still works. Review existing Super Users, blocked states, group assignments, authentication/MFA settings, and logs. If compromise is possible, rotate affected credentials and investigate before closing the incident.
Need More Help with Joomla?
Still having trouble? Open a support ticket with QuantaCade Support and we'll be happy to help where we can.
Support priority is given to QuantaCade products, services, and customers. However, we're also happy to assist fellow Joomla users with general Joomla questions and troubleshooting when possible.
QuantaCade is an independent Joomla extension developer and is not official Joomla support. Some issues involving third-party extensions, hosting environments, server configurations, or other systems outside our development control may be beyond what we're able to resolve.