Monday, February 11, 2019

Wordpress Admin Password Reset using Mysql Shell

INSERT INTO astersignature.wp_users (ID, user_login, user_pass, user_nicename, user_email, user_status, display_name) VALUES ('1000', 'pucadmin', MD5('Str0ngPa55!'), 'pucadmin', 'support@powerupcloud.com', '0', 'pucadmin');


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


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