Recover XenForo Admin Password via phpMyAdmin!

[XMAN]

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', 'testR@local.com', '', '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...