Create a WordPress Admin Account via phpMyAdmin

Have you ever been totally locked out of your WordPress admin account? While it’s normally a rare occurrence, it can happen if your site has been hacked, an accidental deletion or another admin has deliberately deleted you. If your account is totally gone, you will need to create a new one through the database. This article will show you how to do it through phpMyAdmin.

Create an admin user via MySQL

  1. Log into phpMyAdmin
  2. Select correct database
  3. Click on SQL tab
  4. Enter the following SQL (edit to your specs):
  5. Click Go
  6. Log in and strengthen password (or edit SQL with strong password)

Still having trouble?

If you’re still having trouble, start a chat with us, we can probably help. We are rated one of the best WordPress Support Services after all!


Also published on Medium.

Leave a Reply

Your email address will not be published. Required fields are marked *

See if Cinch is right for you.

Ask us anything. Seriously. Like, what is the air speed velocity of an unladen swallow?

Start a chat right now

Or go ahead and Sign up now