Is your administrator account blocked from accessing the WordPress dashboard? This can be due to a code error, a hack, admin account deletion, or a malicious partner changing information on you. 

To regain the access you will have to create a new administrator account. And you will have to do it manually by directly interacting with the database.

If you are hosting your website with Breeze.io, we provide access to your mysql database using phpmyadmin. But in this article, I will show you how to Create New Admin Account in WordPress via MySQL using both cPanel and Breeze.io panel.

Step 1: Access your account

Login to your cPanel account. On the main interface, locate Database category and click on phpMyAdmin.

Create New Admin Account in WordPress via MySQL

Or

If you are a Breeze.io customer login to your account and click on “Manage” next to the site for which you want to create new Admin account in WordPress via MySQL. 

Create New Admin Account in WordPress via MySQL

In the overview tab, copy you database details and click on “Open MySQL Editor” and paste your login details.

Create New Admin Account in WordPress via MySQL

Step 2: Create new Admin account

Once you have entered your account, locate your WordPress database in the left sidebar.

Create New Admin Account in WordPress via MySQL

Once all the database information is loaded, click on SQL tab on the top.

Create New Admin Account in WordPress via MySQL

Copy and paste the following code in the the box. You will have to change the username and password here. For example purpose we will be using the following credentials:

Username: newadmin

Password: password

And here’s the code:

Simply click on “GO” to run the query. Once the screen is refreshed, you will see a message ‘1 row affected’ after every 3 statements. 

You have successfully created a new Admin account in WordPress via MySQL. Go to your WordPress administration dashboard and try to log in with the newly created credentials.

If you need further assistance feel free to contact us!