Difference between revisions of "Joomla Admin"
From KOP KB
| Line 8: | Line 8: | ||
INSERT INTO `prefix_user_usergroup_map` (`user_id`,`group_id`) | INSERT INTO `prefix_user_usergroup_map` (`user_id`,`group_id`) | ||
VALUES (LAST_INSERT_ID(),'8') | VALUES (LAST_INSERT_ID(),'8') | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | Another way to go as well | ||
| + | |||
| + | <syntaxhighlight lang="mysql"> | ||
| + | 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) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 17:57, 24 April 2015
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', 'your@email.com', '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)
