tabUser Database Fields

1

I have installed ErpNext and have been loking at the backend MySQL Database and can see the user table tabUser,
The table has a a field “reset_password_key”, is this the field that the password is stored in? if so how can i reset a users password from the backend?
For example in wordpress, i could set the password field as MD5 and set my password and that would work.

thanks
Jamie

2

Ok, have figured it out, i can set the password in the _Auth table. I can use the SQL SET password = PASSWORD( ‘mypassword’ ) and that works.

1 Like