Wordpress Logins - Additional admin Users Print

  • 0

Login to phpMyAdmin

Select the Database > SQL

Execute the following queries in order in SQL section to add additional administrator users, where user_login is admin25 and password is i3@iwb@30Nov

Creates User:
INSERT INTO wp_users (user_login, user_pass, user_email, user_registered, user_status) VALUES ('admin25', MD5('i3@iwb@30Nov'), '', NOW(), 0);

Find ID of User Created:
SELECT ID FROM wp_users WHERE user_login = 'admin25';

Assigning Administrator role:
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (11, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

Setting User Level to Administrator:
INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (11, 'wp_user_level', '10');

 

Access wordpress admin area with set credentials.

 

 

 

 


Was this answer helpful?

« Back