Create a WordPress Admin user for a WordPress Site via MySQL Print

  • 0

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:


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

Was this answer helpful?

« Back