I want to update passwords for some users using mysql (terminal) not GUI, which should be faster.
But I couldn’t find which table that contains that users’ passwords
I searched in tabUser table but it doesn’t have a column like this.
where can I find it and is it possible to change password in this way?
I did this a few years ago; here’s some notes I took that might help you:
- The User passwords are saved in a special table named ‘
SELECT doctype, `name`, fieldname, `password`, encrypted
WHERE doctype = 'User'
AND fieldname = 'password'
The passwords are hashed. So, to update via SQL alone? You must first (outside of SQL), determine the hashed value for each plain-text password.
To see how this is accomplished with the Frappe framework, examine the file ‘
Here’s a link with more information about the passlib library:
Thank you @brian_pond that was helpful. but since I can’t update directly from SQL and it requires Hash, it will take long time to solve.
I found another solution that I can export the list of users as an Excel sheet then update the “Set New Password” column to the new password then import it to the system. Here I can change the password for all users at once.