To create a new admin account. For developers who want to speed this process up, you will need to do this by interacting directly with database. Below is a step by step guide for doing just that.

Creating a new admin account via MySQL

  1. To begin, log into your cPanel interface.
  2. From the main cPanel screen, find the Databases category and click on the icon entitled phpMyAdmin.
    add admin via mysql
  3. Once the first screen appears, look to the left hand sidebar and click on the database for your specific WordPress installation. If you do not know which database is the correct one, you can review step 1 in the previous article.
  4. After the database information loads, you will need to find the tab named SQL and click on it.
  5. This leads you to an SQL editor where you will enter some code that will creat a new admin account for you. Below is the code to create a new admin account named admin with the password admin123. You may change any content that has underlining red to fit your needs, but leave all other data as is.
  6. After replacing any data fields you need, click the Go button to perform the insertion
  7. This should simply refresh the screen and you should see the message ‘1 row affected’ after each of the three SQL statements. This means the insertion ran smoothly. From here, visit your wordpress admin login area as normal and use the new admin login information. You should get to the admin interface without issue.


Note: the following instructions assume that your database table prefix is set to “wp_“. If you are using something different, then make sure to adjust your code accordingly. For example, if you are using “wptables_”  instead of “wp_“, then the code INSERT INTO `wp_users`”  would be “INSERT INTO `wptables_users`”.