WordPress - Create admin account

Simply create new account directly in WordPress database. If you have access to WordPress database running on MySQL but not to WordPress admin you can  “hack” it.

Script source: https://www.hostpapa.ca/knowledgebase/create-admin-account-wordpress-via-mysql/

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
VALUES ('rybnitom', MD5('Pa$$w0rd'), 'Tomas Rybnicky', 'tomas.rybnicky@wetory.com', '0');
 
INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
 
INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');

Leave a Reply