How to Add New WordPress Logins via phpMyAdmin

Follow these steps to add new WordPress logins via phpMyAdmin:

First, you will need to find which database your website is utilising. To do this, you will need to access your wp-config file within your File Manager.

1. Log in to your cPanel account. For instructions on how to log in to cPanel, please click here.

2. Under the Files section, click File Manager.

3. Go to the location where your wp-config file is (most commonly stored in public_html with your other website files).

4. Once you have located your wp-config file, right-click the file, then click View.

5. This will display the contents of the wp-config file. Look for the code that says: define( ‘DB_NAME’, ‘NameOfDatabase’ );

The database name will be noted where ‘NameOfDatabase’ is listed in the above code. In this example, the database name is ‘tofumomo_wp194’.

Now that you have the name of the database, you will need to access phpMyAdmin in your cPanel.

6. Under the Databases section, click phpMyAdmin.

7. On the left-hand side panel, select the database that was listed in your wp-config file. (In this case, the database is ‘tofumomo_wp194’, as per the previous screenshots).

8. Once you select the database, it will provide you with a list of tables. You need to locate the table that includes the list of users who can access your WordPress backend.

This table may have different names depending on how the website was built. In most cases, it will contain the word ‘users’ in the name. In this scenario, the table name you want to select is ‘wpa9_users’. This will open up a list of entries within the table ‘wpa9_users’.

9. At the top of the page, you will see a row of tabs, click the Insert tab. This will open up a page that allows you to insert new entries into the table.

10. On this page, you can enter your new user login details.

Refer to the list below for each section that is required and what they are for.

• user_login: Insert the username you want to use for your new admin user. (In our example, it is ‘example’.)
• user_pass: Add a password for the account and select MD5 in the Function drop-down. (In this example, it is ‘ExamplePassword65’.)
• user_email: Add the email address you want to use.
• user_registered: Select the date and time for when this user should be registered.
• user_status: Set this value to 0.

You can leave the ID row blank, the ID is a unique identifier and will be assigned automatically.

11. Once your new WordPress login entries have been filled out, click Go. This will take you to another page advising that the row/entry has been added.

12. This will take you to another page advising that the row/entry has been added.

13. Click back into the table name again ‘wpa9_users’.

14. Look for the new WordPress login entry. You will now need to note down the ID value. This is so we can link the permissions for the account. In this case, the ID is “2”.

15. Back on the left-hand side panel, select the table that includes the word ‘usermeta’ in the name. In this scenario, the table name you want to select is ‘wpa9_usermeta’.

16. This will list the entries within the table. Click the Insert tab at the top of the page.

17. On this page, you can enter your new user login details.

Refer to the list below for each section that is required and what they are for.

• user_id: Fill in the ID of the user you created in the previous step. (In this case, the ID was “2”.)
• meta_key: The prefix of your table name followed by capabilities. By default, database tables usually start with wp_. However, in this case, the preluded text is wpa9_. Therefore, we would enter the text wpa9_capabilities.
• meta_value: Fill in the field with a:1:{s:13:”administrator”;s:1:”1″;}

18. Once these entries have been added, click Go.

19. This will take you to the next page to confirm the entries have been added to the table.

Congratulations! You can now log in using your new WordPress login 🙂