Skip to content

Instantly share code, notes, and snippets.

@seuntaylor

seuntaylor/insert_user.sql

Last active February 20, 2019 15:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save seuntaylor/bed2639d8b49584dd9c1d3338175955b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save seuntaylor/bed2639d8b49584dd9c1d3338175955b to your computer and use it in GitHub Desktop.
Download ZIP
Create a WordPress Administrator account directly from the
Raw
insert_user.sql
INSERT INTO `a80vm_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
VALUES ('85485', 'QuietAdmin', MD5('C[u0(RsH8!3Xlkp0{lP#'), 'Quiet Administrator', 'my@email.co', '0');
INSERT INTO `a80vm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, '85485', 'a80vm_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `a80vm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, '85485', 'a80vm_user_level', '10');
@seuntaylor
Copy link
Author

seuntaylor commented Jun 7, 2018

Make sure you change the values in the second like to what you would want - QuietAdmin, C[u0(RsH8!3Xlkp0{lP#, Quiet Administrator and my@email.co. You can also change the user_id value to something else (an integer please!)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment