Add New Joomla Admin using phpmyadmin

bockey Joomla Fixes 12 April 2025 Hits: 195

Need to quickly add a new Joomla admin user but can't access the backend? Using phpMyAdmin, you can manually create an administrator account directly in the database. This trick is especially handy when you're locked out or recovering a hacked site.

INSERT INTO `database`.`prefix_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES ('62', 'Super User', 'user', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', '5f4dcc3b5aa765d61d8327deb882cf99', 'Super Administrator', '0', '1', '2012-08-06 00:00:00', '2012-08-06 00:00:00', '', '{}');

Change database to actual database name If you don’t know database name site’s using, it’s in configuration.php file, search for public $db.
Change prefix_to database’s prefix.
In this example, login name is user and password is password ( password will be stored in database as 5f4dcc3b5aa765d61d8327deb882cf99.

Boki

With more than 15 years of hands-on experience in Joomla, the author specializes in building and redesigning websites that are both functional and easy to use. Driven by a passion for clean code and thoughtful design, they help individuals and businesses bring their digital ideas to life—turning concepts into smooth, engaging online experiences.

Tips & Tricks