Advertisement
shaashwato1308

WordPress - Adding Admin User form MySQL

Jan 26th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.51 KB | None | 0 0
  1. INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
  2. VALUES ('to_edit_username', MD5('to_edit_password'), 'Super Admin', 'contact@.com', '0');
  3.  
  4. INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
  5. VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
  6.  
  7. INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
  8. VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement