* Do note that this guide is just to create an administrator strictly for login access and administrative purposes. Not recommended for normal usage in WordPress.
To create an administrator in the database, we need to add data into 2 tables, wp_users and wp_usermeta.
In wp_users table, insert a row with the following fields:
user_login – The login name to WordPress Dashboard
user_pass – The login password, needs to be a MD5 hash. Link to MD5 generator
In wp_usermeta table, insert a row with the following fields to provide the newly create user with administrative rights:
user_id – The id of the user that you have just created
meta_key – Enter “wp_capabilities” (without quotes)
meta_value – Enter “a:1:{s:13:”administrator”;s:1:”1″;}” (without quotes)
Yup, that’s all for now 
