bbPress

Info

• 5 posts
• 2 voices
• Started 1 year ago by Pagal
• Latest reply from Pagal
• This topic is not resolved

Tags

• admin
• lost
• mass delete

• Posts in this topic

I've lost my admin account!!!

1. • 
   • Pagal
   • Member

   • Posted 1 year ago #

   Recently I've installed the the mass delete plugin.. but by mistake I delete my admin account.
   Now there is no email or user name of my admin.. And I cannot go to my admin panel.
   How can i recover my admin account?
   I don't want to reinstall bbpress

   Thanks
2. • 
   • Gautam
   • Member

   • Posted 1 year ago #

   Do you have access to your database? If yes, then create a new user which you want to be the admin. Then open your database through phpMyAdmin and open the database used in your bbPress install. A lot of tables would load in the left, click on the box like thing in the left of bb_users (or TABLEPREFIXusers), see the user you just created and note the ID in the left of it. Next, click the box in the left of bb_usermeta and then in the above part of right, click the SQL tab. In the textbox that appears, paste this:
   UPDATE bb_usermeta
   SET meta_value = 'a:1:{s:9:"keymaster";b:1;}'
   WHERE user_id = '%%USERID%%' AND meta_key = 'bb_capabilities'`

   Don't forget to replace %%USERID%% with the id you noted down before.
3. • 
   • Pagal
   • Member

   • Posted 1 year ago #

   @ Gautam .....Yes I've access to my database
   what next?
4. • 
   • Gautam
   • Member

   • Posted 1 year ago #

   Sorry, the correct command is:

   UPDATE bb_usermeta SET meta_value = 'a:1:{s:9:"keymaster";b:1;}' WHERE user_id = %%USERID%% AND meta_key = 'bb_capabilities' LIMIT 1

   Replace %%USERID%% with user id
5. • 
   • Pagal
   • Member

   • Posted 1 year ago #

   @ Gautam .. you are trying to confuse me :-s

6. You must log in to post.