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.