Joomla Admin
From KOP KB
Source:https://docs.joomla.org/How_do_you_recover_or_reset_your_admin_password%3F
INSERT INTO `prefix_users`
(`name`, `username`, `password`, `params`)
VALUES ('name', 'username',
md5(password), '')
INSERT INTO `prefix_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8')
Another way to go as well
INSERT INTO `jos_users`
(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`)
VALUES
(62, 'Your Name', 'your_username', '[email protected]', 'f9451cee0c57d483d91bb611ae677999', 'Super Users', 0, 1, '2011-11-30 03:57:21', '2013-09-17 09:58:21', '', '{}', '0000-00-00 00:00:00', 0)
INSERT INTO `jos_user_usergroup_map`
(`user_id`, `group_id`) VALUES(62, 8)