How to change 'admin' password for webpasswordsafe (we forgot admin password)

[pande2411]

By mistake we forgot admin password for “webpasswordsafe”
Please let us know how to change admin password.
As I am new to this please give details steps to change password for Admin user. :)
Thanks in advance. ;)

[pande2411]

did you get a chance to look into this.
Could you please help me on this.

[tetlowgm]

I'm going to make a couple of assumptions here: You are using MySQL. If this is the case, you need to do something like this: Shutdown your instance of WPS. Connect to the database on the commandline. Once connected to the database and switched to the appropriate database, figure out the id of the admin user: select id from users where username = 'admin'; On my system, this is userid 2, but YMMV. Next get the id of a user you know the password for: select id from users where username='username_you_know_password'; For argument sake, let's say the userid is 5 for this one. Next, you need to get the password hash for the user you know: select password from user_authn_password where user_id = 5; For argument sake, let's say the hash is 'QWERTYUIOP' (it'll be much longer than this). Now update the admin user's password with the hash for the one you know: update user_authn_password set password = 'QWERTYUIOP' where user_id = 2; Assuming all of that worked, go ahead and startup your WPS instance and login with the password you know. Best, Gordon

…

On Wed, Jan 11, 2017 at 11:53 PM, pande2411 ***@***.***> wrote: did you get a chance to look into this. Could you please help me on this. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#125 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKEL8Lx0Sj-pACDJ8j5Js5UkcggEYDViks5rRdv8gaJpZM4LfCpf> .