Adding A New WordPress User Manually

Access Your Database


phpMyAdmin is normally what you will use to access your database this button is normally located on your control panel’s main page.


Execute this query replacing the values with your own data

Select your database on the left and click the SQL tab at the top to run a query on the database.
Replace these
with actual data


	INSERT INTO `***DBNAME***`.`***DBPREFIX***users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('101', '***USER***', MD5('***PASS***'), '***NICENAME***', '***EMAIL***', '', '2015-06-07 00:00:00', '', '0', '***DISPLAYNAME***');
	INSERT INTO `***DBNAME***`.`***DBPREFIX***usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '101', '***DBPREFIX***capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
	INSERT INTO `***DBNAME***`.`***DBPREFIX***usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '101', '***DBPREFIX***user_level', '10');