1. Home
  2. Knowledge Base
  3. cPanel
  4. MySQL Databases
  5. Create a WordPress Admin user for a WordPress Site via MySQL

Create a WordPress Admin user for a WordPress Site via MySQL

Step 1: Log into your cPanel.
Step 2: Go to “Database” section and click on PHPMyAdmin icon.
Step 3: Select your WordPress database from the list of databases in PhpMyAdmin.
Step 4: Go to the WP Users table and click on the “insert” link.
Step 5: You will need to fill in the necessary fields to insert a new user record.
Step 6: The final step where we will assign some user meta values to the user account we just created.

Go to the “wp_usermeta” table and click on the “insert” link

Step 7: Use the following values and click the “Go” button to insert the usermeta data.

unmeta_id – Leave it blank (it will be generated for you)
user_id – This is the ID of the user we created in the previous step.
meta_key – Use wp_capabilities
meta_value – Use the following value for this field:
a:1:{s:13:”administrator”;s:1:”1″;}

Step 8: Now log into your WP site using this newly created WP User account.

Related Articles