Difference between revisions of "Joomla Admin"
From KOP KB
(Created page with "Source:https://docs.joomla.org/How_do_you_recover_or_reset_your_admin_password%3F <syntaxhighlight lang="mysql"> INSERT INTO `prefix_users` (`name`, `username`, `password`...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
INSERT INTO `prefix_users` | INSERT INTO `prefix_users` | ||
(`name`, `username`, `password`, `params`) | (`name`, `username`, `password`, `params`) | ||
| − | VALUES ('name, 'username', | + | VALUES ('name', 'username', |
md5(password), '') | md5(password), '') | ||
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> | ||
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)
