Xenforo 2 Recover XenForo Admin Password via phpMyAdmin!

[Sonia]

You will need to edit or update the following tables(as needed):

xf_user
xf_user_option
xf_user_authenticate
xf_admin

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

You can edit as needed:

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');

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')

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

INSERT INTO `xf_admin` (`user_id`, `extra_user_group_ids`, `last_login`, `admin_language_id`, `advanced`, `is_super_admin`) VALUES ('5', 0x33, '1623557408', '0', '0', '1')

Then you can login as Admin with your new account .