How to add new WordPress administrator user via mysql command line

Backup firstly your database using mysqldump command

mysqldump your_database > your_database.sql

mysql>

INSERT INTO `your_database`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, `display_name`) VALUES ('1000', 'newadminuser', MD5('55new_strong!_!p@ssword55'), 'newadminuser', '[email protected]', '0', 'Admin User');

 

 

INSERT INTO `your_database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');

 

 

INSERT INTO `your_database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_user_level', '10');

 

 

UN: newadminuser

PW: 55new_strong!_!p@ssword55

ID: 1000

EMAIL: [email protected]

 

Similar Posts:

    None Found

Leave a Reply

Your email address will not be published. Required fields are marked *