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

  Web Hosting, WordPress FAQ

Dashain Web Hosting Offer

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.

Dashain Web Hosting Offer