Back

Create a WordPress Admin User from Database

Some times you may loose access to your WordPress backend and no other admin login details available. Just paste the following code in your phpmyadmin sql tab, update syntax including ID (4 in the case), and run the syntax. You should have successfully created a new admin user. 

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'demo', MD5('demo'), 'Your Name', '[email protected]', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name'); INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'); INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');

Leave A Reply

Your email address will not be published. Required fields are marked *

Applications for new entry will be open from April 10, 2023, to May 10, 2023.