How to Add an Admin User to the WordPress Database from phpMyAdmin?

Steps to add an Admin user to the WordPress database from phpMyAdmin:

• Log in to cPanel.
• Navigate to the Databases section and click on phpMyAdmin.
• Choose your database. It might be possible that you have multiple databases in your phpMyadmin.

So to find the appropriate database name just follow these steps:

• On the cPanel dashboard, click on File Manager.
• Go to the public_html folder and click on wp.
• On the right side, you will get files and folders in that, right-click on the wp-config.php file and click on the view option.
• In this section, you will see the database name.

• Now, go back to phpMyAdmin and click on the databasename_users table. In our case, the database table name is this.

• Click on Insert.
• Fill the required information in the mentioned fields.

• In the user_pass dropdown, select MD5.

• Click on Go.
• Click on the databasename_users table.
• As you can see the recently added record with ID. In the next step, we will use this id in the user_id field.
• Select the databasename_usermeta table and click on Insert.
• Enter the id of the user which we have created in the previous query.
• In the meta_key textbox, enter the databasename_capabilities. In our case, meta_key is this.

• In the meta_value textbox add this code: a:1:{s:13:”administrator”;s:1:”1″;}
• Again in this section, enter the user_id.
• In the meta_key textbox, enter the databasename_user_level. In our case, meta_key is this.

• In the meta_value textbox, enter the value as 10.
• Click on Go.

Now, follow the steps to check the newly added admin user in WordPress:

• Log in to WordPress with a newly created username and password.
• Click on Users.
• As you can see the newly created username with Administrator role.

That’s how you can add an admin user to the WordPress Database from phpMyAdmin.