Quickly inserting a user into WordPress

February 18, 2016 Rob Programming 0

assuming you know the hash of your password you can insert an account with the following sql

INSERT INTO `wp_users` 
(
  `user_login`,
  `user_pass`,
  `user_nicename`,
  `user_email`,
  `user_url`,
  `user_registered`,
  `user_activation_key`,
  `user_status`,
  `display_name`)
VALUES ('SOMEUSERNAME','SOMEPASSWORDHASH','SOMENICKNAME','SOME@EMAIL.ADDR','','1955-11-05 00:00:00','SOMEACTIVATIONKEY',0,'SOMEDISPLAYNAME');

INSERT INTO `wp_usermeta`
(
  `user_id`,
  `meta_key`,
  `meta_value`)
SELECT
  `ID`,
  'wp_capabilities',
  'a:1:{s:13:\"administrator\";b:1;}'
FROM `wp_users`
WHERE `user_login`='SOMEUSERNAME';