进入phpMyAdmin, 选择 用户数据库 wp_users 或者 (前缀)_users

 

ID – pick a number (in our example, we will use the number 4).

user_login – insert the username you want to use to access the WordPress Dashboard.

user_pass – add a password for this username. Make sure to select MD5 in the functions menu (Refer to the screenshot below).

user_nicename – put a nickname or something else that you would like to refer yourself as.

user_email – add the email you want to associate with this account.

user_url – this would be the url to your website.

user_registered – select the date/time for when this user is registered.

user_status – set this to 0.

display_name – put the name you like to display for this user on the site (it can be your user_nicename value as well).

权限数据库为wp_usermeta 或者 (前缀)_usermeta

 

unmeta_id – leave this blank (it will be auto-generated)

user_id – this will be the id of the user you created in the previous step. Remember we picked 4.

meta_key – this should be wp_capabilities

meta_value – insert this: a:1:{s:13:”administrator”;s:1:”1″;}

Insert another row with the following information:

 

unmeta_id – leave this blank (it will be auto-generated)

user_id – this will be the id of the user you created in the previous step. Remember we picked 4.

meta_key – this should be wp_user_level

meta_value – 10

全部过程总结为：

 

INSERT INTO `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'), 'tester', 'test@yourdomain.com', 'https://www.ldhost.cn/help/', '2014-03-14 00:00:00', '', '0', 'tester');

 

INSERT INTO `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 `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');

 

 

添加编辑员

 

INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('77', 'demo', MD5('demo'), 'tester', 'news@123-reg.co.uk', '', '2016-07-17 00:00:00', '', '0', 'tester');

 

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '77', 'wp_capabilities', 'a:1:{s:6:"editor";b:1;}');

 

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '77', 'wp_user_level', '7');