0

Add new admin user in WordPress from PHPMyAdmin

By 9th February 2016Blog

Similar to another post which does the same thing in OpenCart, here’s how to add a new admin-level user to WordPress – without any access to the wp-admin area. I find this useful when I’m called in to finish off an abandoned website and have no idea what the login credentials are – I’ll simply create my own.

For this, you need access to PHPMyAdmin, which is usually accessed from the server or host control panel.

INSERT INTO `database_name`.`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', 'test@yourdomain.com', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');
INSERT INTO `database_name`.`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 `database_name`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');

 

Obviusly, you need to add your own details to ‘database_name’ and if you want the login to be different to u: demo / p: demo.

Phil

Phil

I'm a Wordpress web developer and website designer based in Cheshire, UK. I specialise in Wordpress, Responsive design and website conversion. | Twitter | Linkedin

Leave a Reply