Skip to content

Instantly share code, notes, and snippets.

@dannyconnolly

dannyconnolly/Create an admin user in wordpress with SQL

Created June 12, 2014 13:21
Show Gist options
  • Save dannyconnolly/c8640bc4b4c8bfb38edf to your computer and use it in GitHub Desktop.
Save dannyconnolly/c8640bc4b4c8bfb38edf to your computer and use it in GitHub Desktop.
Download ZIP
Create an admin user in wordpress with SQL
Raw
Create an admin user in wordpress with SQL
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 ('ID', 'USERNAME', MD5('PASSWORD'), 'USERNICENAME', 'USEREMAIL', '', '0000-00-00 00:00:00', '', '0', 'DISPLAYNAME');
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'ID', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'ID', 'wp_user_level', '10');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment