In PHP MY Admin run

 

Find unactivated WordPress accounts

SELECT `user_id`, `meta_key`, `meta_value` FROM `wp_usermeta` WHERE `meta_key` = ‘wcj_is_activated’ AND `meta_value` = 0

SELECT
`wp_users`.user_login,
`wp_users`.user_nicename,
`wp_users`.user_email,
`wp_users`.display_name,
`wp_usermeta`.meta_value AS `Activated`
FROM
`wp_usermeta`
INNER JOIN
`wp_users`
ON `wp_usermeta`.user_id = `wp_users`.ID
WHERE
`wp_usermeta`.meta_key = ‘wcj_is_activated’
AND `wp_usermeta`.meta_value = 0

Specific user.

SELECT
`wp_users`.user_login,
`wp_users`.user_nicename,
`wp_users`.user_email,
`wp_users`.display_name,
`wp_usermeta`.meta_value AS `Activated`,
`wp_usermeta`.umeta_id
FROM
`wp_usermeta`
INNER JOIN
`wp_users`
ON `wp_usermeta`.user_id = `wp_users`.ID
WHERE
`wp_usermeta`.meta_key = ‘wcj_is_activated’
AND `wp_usermeta`.meta_value = 0
AND `wp_users`.user_email = ‘jasw@cwgsy.net’

To activate all unactivated accounts.
UPDAte SPECifiC
UPDATE wp_usermeta SET meta_value=1
WHERE `wp_usermeta`.`meta_key` =’wcj_is_activated’ AND `wp_usermeta`.`meta_value` = ‘0’ AND `wp_usermeta`.`umeta_id` = ‘52447’
To resend password reset link use plugin