Last Updated: June 10, 2021 | Reading Time: < 1 minute
Open your PHPMyAdmin from your cPanel or Self-Installed mode.
Select related database to your WordPress Install, and click SQL tab. Input the command below.
Just change the orange colored text acording to your desired login, password and other entries.
INSERT INTO 'wp_users' ('ID', 'user_login', 'user_pass', 'user_nicename', 'user_email', 'user_url', 'user_registered', 'user_activation_key', 'user_status', 'display_name') VALUES ('25', 'pupung', MD5('yourpassword'), '', '[email protected]', '', '0000-00-00 00:00:00.000000', '', '0', 'Pupung');
INSERT INTO 'wp_usermeta' ('umeta_id', 'user_id', 'meta_key', 'meta_value') VALUES (NULL, '25', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
INSERT INTO 'wp_usermeta' ('umeta_id', 'user_id', 'meta_key', 'meta_value') VALUES (NULL, '25', 'wp_user_level', '10');
The number 25 is the user’s unique ID, you can change the number to a random number, or review the table wp_users, for un-used ID.
Click “Go” to run the command. That’s it.