How to create a new WordPress admin via MySQL Print

If you are ever locked out of your WordPress site or you need to gain admin access to a WordPress site that you are working on, you can create a new admin user in the database.

Simply use the following MySQL queries to create the new user account. Be sure to replace the following variables in the query below with your information:

your_username
your_password
your_firstname
your_lastname
your_email@your_domain.com

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
VALUES ('your_username', MD5('your_password'), 'your_firstname your_lastname', 'your_email@your_domain.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');