Activate user in PHP

see https://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/

Thanks but that doesn’t show or tell me how to ‘activate’the user. I have inserted a new user but need them activated.

Core wordpress has no concept of “activation” for a user added like that. What plugin are you using for that?

I added the user just like the link you suggested. However the website is set to only allow ‘activation’ manually (by selecting activate user on their profile).
Therefore, I can’t get the new admin account to login as it has not been ‘activated’ by an admin, which is me, and I’m locked out.

AGain, what plugin are you using for that?