Turned myself to editor in error now cant login as admin

  • Resolved Edinburghkate

    (@edinburghkate)


    10 years, 5 months ago

    Hi

    I have been really dumb. I misunderstood something I read, and thought I needed to have 2 logins, one for admin and one to write. My old admin username is now no longer recognised (I don’t know why) and I can only log in as as an editor.

    I can’t reset using email as it only emails me the editor password.

    I am hoping I won’t have to start again with a new site.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator James Huff

    (@macmanx)

    Access your database via phpMyAdmin (most hosting providers offer this in their control panel), go to the wp_users table and find the row for your user_login . Note the ID of this row. Now, go to the wp_usermeta table and find the wp_capabilities row for your user_id . Set the value of this row to a:1:{s:13:"administrator";b:1;}

    Thread Starter Edinburghkate

    (@edinburghkate)

    Hi Brilliant. I already had an admin wp_capabilities row for the other username which I couldn’t log in with so copied that – it was slightly different from yours.

    a:1:{s:13:”administrator”;s:1:”1″;}

    It worked!

    Thank you so much for taking the time to help.

    Moderator James Huff

    (@macmanx)

    You’re welcome!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Turned myself to editor in error now cant login as admin’ is closed to new replies.