Sometimes, you inherit or bork a WordPress Site, and need to manually get access.

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 (‘3’, ‘vcadmin’, MD5(‘newpassword’), ‘vcadmin’, ‘support@v-consulting.com’, ‘https://v-consulting.com/’, ‘2021-03-01 16:00:00’, ”, ‘0’, ‘vcadmin’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, ‘3’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, ‘3’, ‘wp_user_level’, ’10’);