Skip links

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.

How to Add New WordPress Logins via phpMyAdmin

 

2. Under the Files section, click File Manager.

How to Add New WordPress Logins via phpMyAdmin

 

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

How to Add New WordPress Logins via phpMyAdmin

How to Add New WordPress Logins via phpMyAdmin

 

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

How to Add New WordPress Logins via phpMyAdmin

 

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’.

How to Add New WordPress Logins via phpMyAdmin

 

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.

How to Add New WordPress Logins via 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).

How to Add New WordPress Logins via phpMyAdmin

 

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’.

How to Add New WordPress Logins via phpMyAdmin

 

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

How to Add New WordPress Logins via phpMyAdmin

 

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 assign automatically.

How to Add New WordPress Logins via phpMyAdmin

 

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.

How to Add New WordPress Logins via phpMyAdmin

 

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

How to Add New WordPress Logins via phpMyAdmin

 

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”.

How to Add New WordPress Logins via phpMyAdmin

 

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’.

How to Add New WordPress Logins via phpMyAdmin

 

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

How to Add New WordPress Logins via phpMyAdmin

 

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: Is 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″;}

How to Add New WordPress Logins via phpMyAdmin

 

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.

How to Add New WordPress Logins via phpMyAdmin

 

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