krlaboratories

How add new WordPress admin via phpmyadmin

Nov 1st, 2022 (edited)
1,518
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.73 KB | None | 0 0
  1. Log in to phpmyadmin, choose your database and run commands below in console:
  2.  
  3. INSERT INTO `prefixdatabase_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES ('administrator', MD5('yourpassword'), 'User Name', '[email protected]', '0');
  4.  
  5. INSERT INTO `prefixdatabase_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'ID_of_new_user_see_in_wp_users', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
  6.  
  7. // if dont worked 'a:1:{s:13:"administrator";s:1:"1";}' use 'a:1:{s:13:"administrator";b:1;}'
  8.  
  9. INSERT INTO `prefixdatabase_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'ID_of_new_user_see_in_wp_users', 'wp_user_level', '10');
  10.  
  11. DONE.
Tags: wordpress
Advertisement
Add Comment
Please, Sign In to add comment