Recover XenForo Admin Password via phpMyAdmin!

XMAN

Active member
Joined
Jul 12, 2021
Messages
19,642
Reaction score
72
Points
38
You will need to edit or update the following tables(as needed):

Please Login or Register to view content

(In this Tutorial I created new User with ID number 5 , with username named : "Moro" & Password "1234"

You can edit as needed:

SQL:

INSERT INTO `xf_user` (`user_id`, `username`, `username_date`, `username_date_visible`, `email`, `custom_title`, `language_id`, `style_id`, `timezone`, `visible`, `activity_visible`, `user_group_id`, `secondary_group_ids`, `display_style_group_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `conversations_unread`, `register_date`, `last_activity`, `last_summary_email_date`, `trophy_points`, `alerts_unviewed`, `alerts_unread`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `user_state`, `security_lock`, `is_moderator`, `is_admin`, `is_banned`, `reaction_score`, `vote_score`, `warning_points`, `is_staff`, `secret_key`, `privacy_policy_accepted`, `terms_accepted`) VALUES ('5', 'Moro', '0', '0', '[email protected]', '', '1', '0', 'Europe/London', '1', '1', '2', 0x33, '3', '4', '0', '0', '0', '1623557907', '1623559078', NULL, '0', '0', '0', '0', '0', '0', '0', '', 'valid', '', '0', '1', '0', '0', '0', '0', '0', 0x52785473653567746f4930686252435f6d76726845304d785a524733727a726c, '0', '0');

SQL:

INSERT INTO `xf_user_option` (`user_id`, `show_dob_year`, `show_dob_date`, `content_show_signature`, `receive_admin_email`, `email_on_conversation`, `push_on_conversation`, `is_discouraged`, `creation_watch_state`, `interaction_watch_state`, `alert_optout`, `push_optout`, `use_tfa`) VALUES ('5', '0', '1', '1', '0', '1', '0', '0', 'watch_email', 'watch_email', '', '', '0')

SQL:

INSERT INTO `xf_user_authenticate` (`user_id`, `scheme_class`, `data`) VALUES (5, 'XF:Core12'...


Read more

Continue reading...
 
  • Tags
    recover xenforo admin password via phpmyadmin! recover xenforo admin password xenforo
  • Top