Wordpress: How to Manually Add Users in wp_user

What you need:
-phpMyAdmin access
-Wordpress Database Name
-Wordpress Database Username
-Wordpress Database Password

If you don't know your wordpress website's DB info, you can locate them in your wp-config.php file (located at the root folder). Although from what I experienced, I did not use the DB login details but still, if ever there will be cases you'll be needing it, it's safer you already know where to find them.

There are 2 tables to edit. First would be wp_users, we will ad a new user profile in this table. Then wp_usermeta, where we will put permissions and privileges.

Adding a user on wp_user:

Click on the wp_user table and then click Insert tab.
Table fields:

ID	By default, this is incremental so leave this blank
user_login	This will be your username for Wordpress access
user_pass	This will be your password for Wordpress access (note: use the function, MD5 - this will make your password encyrpted)
user_nicename	This will be you name displayed on front end pages. This is different with username
user_email	This is your own email address for reference and future password retrieval
user_url	This is your own URL. this is not required
user_registered	Date when you registered
user_activation_key	leave this blank
user_status	leave this set to 0 (zero)
display_name	Same as nicename

If you entered all the necessary details needed, click Go at the bottom of the page.
If there are no errors with the SQL commands then you can proceed to the wp_usermeta table.
(If there are errors, please repeat the insertion of details and double check every word)

Adding user permission on the wp_usermeta:

After adding a user on the wp_user table, we will set administrative permissions to that user by adding wp_capabiilties and wp_user_level on the wp_usermeta table. Before inserting any data here, you must first check and get the ID  that was auto-generated to the ID field from the wp_user table.
Click on the wp_usermeta table, click Insert tab.
Table fields:

Insert data for wp_capabilities

umeta_id	This is Incremental so leave this blank
user_id	Enter the User ID that was auto-generated a while ago from the recent wp_user addition
meta_key	Enter here wp_capabilities
meta_value	Enter here a:1:{s:13:"administrator";b:1;}

Insert new data for wp_user_level

umeta_id	This is Incremental so leave this blank
user_id	Enter the User ID that was auto-generated a while ago from the recent wp_user addition
meta_key	Enter here wp_user_level
meta_value	Enter here 10

Double check everything and then click Go to insert the rows.

After you follow these steps you would now be able to login using your new user account details. You can update you profile information once you enter the admin page.