Difference between revisions of "Joomla Admin"
From KOP KB
| (One intermediate revision by the same user not shown) | |||
| Line 13: | Line 13: | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
| − | INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`) VALUES | + | INSERT INTO `jos_users` |
| − | (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) | + | (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`) |
| − | INSERT INTO `jos_user_usergroup_map` (`user_id`, `group_id`) VALUES(62, 8) | + | 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> | ||
Latest revision as of 18:11, 30 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', '[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)
