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.

sailboat

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
***USER***
***DBNAME***
***PASS***
***DBPREFIX***
***NICENAME***
***EMAIL***
***DISPLAYNAME***
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***', 'www.example.com', '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');