Skip to content

Instantly share code, notes, and snippets.

@jb510
Last active December 16, 2015 07:39
Show Gist options
  • Save jb510/5400655 to your computer and use it in GitHub Desktop.
Save jb510/5400655 to your computer and use it in GitHub Desktop.
# replace databasename, name, fullname, password, email@domain.com, http://domain.com, display_name
# make sure user_id number 99 isn't already in use, if it is change it in all 3 lines.
INSERT INTO `#databasename#`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('99', '#user_login#', MD5('#user_pass#'), '#user_nicename#', '#email@domain.com#', '#http://domain.com#', '2013-01-01 00:00:00', '', '0', '#display_name#');
INSERT INTO `#databasename#`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '99', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
INSERT INTO `#databasename#`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '99', 'wp_user_level', '10');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment