How to Add an Admin to WordPress phpMyAdmin

Jan 11, 2024

When it comes to managing your WordPress website, having control over user access is crucial. In certain situations, you may find it necessary to add an additional admin to your WordPress site using phpMyAdmin. In this comprehensive guide, we will walk you through the process, step-by-step, helping you gain the necessary skills to handle user management effectively.

Why Add an Admin to WordPress phpMyAdmin?

Before diving into the details, it's essential to understand the reasons behind adding an admin via phpMyAdmin. While WordPress provides an intuitive interface for managing users, there might be instances where you are unable to access your WordPress dashboard or you accidentally lost the admin account login credentials. In such scenarios, phpMyAdmin grants you direct access to your WordPress database, allowing you to add a new admin user without depending on the traditional methods.

Step-by-Step Guide: Adding an Admin via phpMyAdmin

Follow these detailed steps to add an admin to your WordPress site using phpMyAdmin:

  1. Accessing phpMyAdmin
  2. In order to begin the process, you need to access your website's phpMyAdmin. Open your preferred web browser and navigate to your hosting control panel. Locate the phpMyAdmin icon or link and click on it to proceed.

  3. Selecting the Correct Database
  4. Once inside phpMyAdmin, you'll see a list of databases associated with your hosting account. Identify the database that corresponds to your WordPress installation and click on it to select it.

  5. Opening the WordPress Users Table
  6. After selecting the correct database, you'll be presented with several tables. Look for the wp_users table and click on it to open it. This table contains all the registered users on your WordPress site.

  7. Inserting a New Admin User
  8. Within the wp_users table, locate the "Insert" or "Add New" button and click on it. You'll be redirected to a new page where you can enter the details of the new admin user.

  9. Providing User Information
  10. Fill out the necessary information for the new admin user. Ensure that you set the appropriate values for the user_login (username), user_pass (password), and user_email fields. For enhanced security, use a strong, unique password.

  11. Assigning User Role
  12. Next, locate the wp_usermeta table and click on it to open. Inside this table, find the meta_key field named "wp_capabilities" and click on the "Edit" button next to it. In the meta_value field, replace the existing value with:

  13. Saving Changes
  14. Once you've completed all the necessary steps, click on the "Go" or "Save" button to save the changes made.

  15. Verifying the New Admin Account
  16. After saving the changes, exit phpMyAdmin and go back to your WordPress login page. Use the newly created admin credentials to log in and verify the successful addition of the new admin account.


By following this step-by-step guide, you have successfully learned how to add an admin to WordPress via phpMyAdmin. Remember, it's important to exercise caution when handling your website's database. Make sure to back up your database before making any changes and always double-check your actions.

Gaining control over your WordPress site's user management can significantly enhance your website administration skills. With the ability to add an admin via phpMyAdmin, you can overcome various challenges and restore access to your website even when conventional methods fail.

Stay in control of your WordPress site and empower yourself with efficient user management techniques. HostingSewa is here to provide reliable hosting solutions and expert guidance to optimize your online presence.

add admin to wordpress phpmyadmin