# How to create a new user in pure sql **URL:** \ **Category:** Migration\ **Created:** [December 19, 2019, 5:15pm UTC](https://meta.discourse.org/t/how-to-create-a-new-user-in-pure-sql/136525 "2019-12-19T17:15:39Z")\ **Posts on this page:** 1\ **Showing post:** 24
**Author:** ![paultaylor](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/paultaylor/32/166024_2.png) [@paultaylor](https://meta.discourse.org/u/paultaylor)\ **Post date:** [December 22, 2019, 10:00am UTC](https://meta.discourse.org/t/how-to-create-a-new-user-in-pure-sql/136525/24 "2019-12-22T10:00:05Z")
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](mailto: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. --- _[View the full topic](https://meta.discourse.org/t/how-to-create-a-new-user-in-pure-sql/136525)._