Identify Relevant Meta Keys: You want to delete the following meta keys:
_two_factor_nonce
_two_factor_last_login_failure
_two_factor_failed_login_attempts
_two_factor_fido_u2f_register_request
_two_factor_backup_codes
_two_factor_enabled_providers
_two_factor_provider
Run SQL Queries to Delete 2FA Data: You can delete the data for the specific user by running the following SQL queries. Replace 1 with the actual user_id of the user affected.
Run SQL Queries:
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_nonce';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_last_login_failure';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_failed_login_attempts';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_fido_u2f_register_request';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_backup_codes';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_enabled_providers';
DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = '_two_factor_provider';
These queries will delete the 2FA-related data for the user with user_id = 1. Make sure to adjust the user_id if needed.
Verify the Deletion: After running the queries, you can verify that the rows have been deleted by running:
SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key LIKE ‘_two_factor%’;
