Skip to:
Content
Pages
Categories
Search
Top
Bottom

I've lost my admin account!!!


  • pagal
    Participant

    @pagal

    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

Viewing 4 replies - 1 through 4 (of 4 total)

  • Gautam
    Member

    @gautam-gupta

    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.


    pagal
    Participant

    @pagal

    @ Gautam …..Yes I’ve access to my database

    what next?


    Gautam
    Member

    @gautam-gupta

    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


    pagal
    Participant

    @pagal

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Skip to toolbar