How can i recover or reset jira system admin password in sql db

Question

i know i must update the cwd_users credential in sql but dont know how to hash the password

Dom_deb441 · Answer

Before posting i had already read the doc you suggested. My ask was specifically, to be able to create a hash for a password of my choice rather than "sphere". But shortly after I realized that the simplest way would be to set the passwd to "sphere" acquire admin access through the UI and reset the password once i am in.

thanks

Alexey Matveev · Answer

Hello,

Kindly read this KB:

https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html?_ga=2.222331986.856277697.1543736872-65270402.1526147845