To add or remove a WordPress admin user using phpMyAdmin

To add or remove a WordPress admin user using phpMyAdmin, you'll need to access your WordPress database and make changes to the wp_users table. Here's a step-by-step guide:

Adding an Admin User:

1. Access phpMyAdmin:

   • Log in to your web hosting control panel.
   • Find and open phpMyAdmin.

2. Select Your WordPress Database:

   • In phpMyAdmin, locate and select your WordPress database from the list on the left-hand side.

3. Open the wp_users Table:

   • Once inside your WordPress database, find and click on the wp_users table. It should be listed in the sidebar.

4. Insert a New Admin User:

   • Click on the "Insert" tab or "Insert" button (depending on your phpMyAdmin version).
   • Fill in the required fields for the new admin user:
     • user_login: Enter the desired username for the new admin user.
     • user_pass: Enter a password for the new admin user. Make sure to select "MD5" from the dropdown menu for the password field.
     • user_nicename: Enter the display name for the new admin user.
     • user_email: Enter the email address for the new admin user.
   • Leave the ID field blank as it will auto-increment.

5. Assign Admin Role:

• After inserting the new user, you need to assign them the admin role. To do this, open the wp_usermeta table.
• Look for the wp_capabilities row where the meta_key is wp_capabilities and the user_id corresponds to the ID of the new user you just added.
• Change the meta_value to:
6. a:1:{s:13:"administrator";s:1:"1";}

1. • This sets the user as an administrator.

2. Save Changes:

   • Click on the "Go" or "Save" button to save your changes.

Removing an Admin User:

1. Access phpMyAdmin:

   • Follow steps 1 and 2 from the previous section to access phpMyAdmin and select your WordPress database.

2. Delete Admin User:

   • Click on the wp_users table.
   • Find the row corresponding to the admin user you want to delete.
   • Click on the "Delete" button or icon (usually a red 'X') next to the row.

3. Remove Admin Role:

   • Open the wp_usermeta table.
   • Look for the wp_capabilities row where the meta_key is wp_capabilities and the user_id corresponds to the ID of the admin user you want to remove.
   • Delete this row.

4. Save Changes:

   • Click on the "Go" or "Save" button to save your changes.

Remember, making direct changes to your WordPress database can be risky, so be cautious and ensure you have a backup before proceeding. If you're uncomfortable with this process, consider using WordPress plugins or seeking assistance from a professional.