Follow this to insert a new entry in wp_users table:
ID – pick a number next coming digit basically
user_login – insert the username which you will use to access Dashboard
user_pass – add a password for this username. Make sure to select MD5 in the functions menu.
user_nicename – put a nickname for yourself
user_email – add the email you want to associate with this account.
user_url – this would be the url to your website ( optional).
user_registered – select the date/time. (optional)
user_status – set this to 0.
display_name – put the name you like to display for this user on the site (optional)
Click Go Button to save the row
Next you need to add the values to wp_usermeta table. Click on the wp_usermeta table and then insert the following:
unmeta_id – leave this blank (it will be auto-generated)
user_id – same id of the user you created in the previous step.
meta_key – insert wp_capabilities
meta_value – insert this: a:1:{s:13:”administrator”;s:1:”1″;}
Uncheck ignore and Insert another row with the following information:
unmeta_id – leave this blank (it will be auto-generated)
user_id – same id of the user you created in the previous step.
meta_key – insert wp_user_level
meta_value – 10
Thats it!!! Now you can login with your username and associated password.