1,576
edits
Changes
→Part 4: Adding a Secondary Author User To Your Blog
#* <code>SELECT * FROM wp_users;</code>
# Take a look at the '''wp_usermeta''' table. We'll be using both.
# Add a new user with the following command (''', but supply your own username, password, e-mail, blog URL, and current date. ('''WARNING: Do not use the same username as an existing user!'''): <code>INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_status, display_name) VALUES (2, 'cjohnson31', MD5('apassword'), 'cjohnson31', 'cjohnson31@myseneca.ca', 'http://wordpress-env.eba-mukvj5kp.us-east-1.elasticbeanstalk.com', '2020-12-01 03:47:00', 0, 'cjohnson31');</code>
# List your '''wp_users''' table entries again to verify your work.
# Give your new user the ''Author'' role with the following command: <code>INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, '2', 'wp_capabilities', 'a:1:{s:6:"author";s:1:"1";}');</code>
