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
- Log into phpMyAdmin
- Select correct database
- Click on SQL tab
- Enter the following SQL (edit to your specs):
[gist https://gist.github.com/spigotdesign/18a79efed56328779eefa2b469779873 ] - Click Go
- 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!
