Advanced Search

Return to Snippet

Revision: 33513
at October 9, 2010 08:25 by timkinnane
Initial Code 
-- Step 1 Add the user
-- Change db_wordpress to DB name
-- Change wp_ to your table prefix
-- Change username, pass, nicename, email, url, displayname and pass to your new user info
-- Change date to whenever you want the registered date to be
INSERT INTO `db_wordpress`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (NULL, 'username', MD5('pass'), 'nicename', 'email', 'url', '2010-10-08 00:00:00', '', '0', 'displayname');
-- Step 2 Add permissions
-- Find the userid that was just created (int)
-- Replace id with the user id
INSERT INTO `db_wordpress`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'id', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
INSERT INTO `db_wordpress`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'id', 'wp_user_level', '10');
-- Done
Initial URL 
www.owlandfox.com
Initial Description 
When working on client sites, you often need admin access, instead of requiring them to set up an admin user, just make your own. ref:
http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database
Initial Title 
Add Wordpress admin user to database
Initial Tags 
mysql, wordpress, user
Initial Language 
MySQL