t5weMnR0

1Go to SQL
2
3DROP TABLE IF EXISTS wp_users;
4CREATE TABLE wp_users (
5  ID bigint(20) unsigned NOT NULL auto_increment,
6  user_login varchar(60) NOT NULL default '',
7  user_pass varchar(64) NOT NULL default '',
8  user_nicename varchar(50) NOT NULL default '',
9  user_email varchar(100) NOT NULL default '',
10  user_url varchar(100) NOT NULL default '',
11  user_registered datetime NOT NULL default '2018-01-01 01:01:01',
12  user_activation_key varchar(60) NOT NULL default '',
13  user_status int(11) NOT NULL default '0',
14  display_name varchar(250) NOT NULL default '',
15  spam tinyint(2) NOT NULL default '0',
16  deleted tinyint(2) NOT NULL default '0',
17  PRIMARY KEY  (ID),
18  KEY user_login_key (user_login),
19  KEY user_nicename (user_nicename)
20) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
21
22Then
23
24INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
25VALUES ('newadmin', MD5('pass123'), 'firstname lastname', 'email@example.com', '0');
26
27INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
28VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
29
30INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
31VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');