How to create a new user in pure sql

Ah, sorry my bad, i had put the wrong value for password hash into user_custom_fields.okay that fixes it thankyou…

… however

Even though I created the user with activate true, and it says the user is activated when I look at the user from the admin console when try to login it says:

You can’t log in yet. We previously sent an activation email to you at user@email.com . Please follow the instructions in that email to activate your account.

Why do I get that, I was trying to avoid that.