• Report Links
    We do not store any files or images on our server. XenPaste only index and link to content provided by other non-affiliated sites. If your copyrighted material has been posted on XenPaste or if hyperlinks to your copyrighted material are returned through our search engine and you want this material removed, you must contact the owners of such sites where the files and images are stored.

Recover XenForo Admin Password via phpMyAdmin!

XMAN

Active member
Joined
Jul 12, 2021
Messages
19,637
Reaction score
103
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', '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...
 
  • Tags
    recover xenforo admin password via phpmyadmin! recover xenforo admin password xenforo
  • Top