SQL code for use with Joomla Joomla 2.5 Joomla 3.x Joomla 4.x  

INSERT INTO 'jos_users'
('name', 'username', 'password', 'params', 'registerDate', 'lastvisitDate', 'lastResetTime')
VALUES ('Administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '', NOW(), NOW(), NOW());
INSERT INTO 'jos_user_usergroup_map' ('user_id','group_id')
VALUES (LAST_INSERT_ID(),'8');

Please check your table prefix jos_ . The above will create Super Administrator with username “admin2” and password “secret”. After logging in change your details.

If failed above, try below syntex

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (1000000, 'tempsuperuser1', 'tempsuperuser1', 'youremail1@yourjoomlawebsite.com', MD5('temppassword'), '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '0', '', '', '0');
INSERT INTO `jos_user_usergroup_map` (`user_id`, `group_id`) VALUES ('1000000', '8');

The above will create Super Administrator with username “tempsuperuser1” and password “temppassword”. After logging in change your details.

Password = You can choose other password
——————————————————
– admin = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
– secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
– OU812 = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm