Need to reset JIRA admin password or create a new admin

[Thomas Pokorski]

So silly me, I have a JIRA instance local on my home PC (localhost:8080) to play around with stuff and I haven't played in it for so long that I forgot the password I set up for the sole user of the JIRA instance.  

mySQL Community database (5.6.39)

JIRA version is (v7.8.0#78000-sha1:4568b9d)

I tried resetting the password to "sphere" using the method described in the KB

update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX';

replacing XXXX with the username for my lone user.  It executed successfully in mySQL, but when I try to log into JIRA with the user and the password sphere, it fails.  

Update: it eventually ended up working.  Not sure why but there was a delay.  

[Angélica Luz · Accepted solution]

Hi Thomas,

We are glad that you were able to resolve, thanks for sharing.
If you face any issue or have any other question, please let us know.

Regards,
Angélica