new_admin_wordpress.sql

# Adds new account
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
(null, 'firstlastname', 'known-password-hash', 'First Last Name', 'email@example.com', '', NOW(), '', 0, 'First Last Name');

# Selects autogenerated ID
SET @autogenerated_id = LAST_INSERT_ID();

# Setups new account as a WordPress admin
INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(null, @autogenerated_id, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(null, @autogenerated_id, 'wp_user_level', '10');