Adding a user through SQL involves two parts. First, adding a record into the WorPress users table and then second adding a record into the WordPress usermeta table.
The table prefix will likely be different for different WordPress installations. In the code snippets below wp_
is the table prefix, however for your installation it may be wp_sdf235_
, so make sure you are updating references in the code below accordingly.
Insert Record Into WordPress Users Table
Make sure to replace wp_
with the table prefix used in your database.
INSERT INTO `wp_users` ( `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ( 'wplauncher_admin', MD5('password'), 'wplauncher', 'wplauncher@wplauncher.com', '', '2020-01-04 00:00:00', '', '0', 'wplauncher')
Make sure to save the user id after this SQL query is run as it will be used below. You can get the user id by running the query below:
SELECT ID FROM wp_users WHERE user_email = 'wplauncher@wplauncher.com';
Insert Record Into WordPress Usermeta Table
Make sure to replace the number 4 in the code snippet below with the user id that you get above. And, make sure to replace wp_
with the table prefix used in your database. The table prefix is present in wp_usermeta, wp_capabilities, wp_user_level.
INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'), (NULL, '4', 'wp_user_level', '10')