Typically you don't want to create a user in the DB if you can help it. In fact, for all Jira versions higher than 7.0, Atlassian recommends using the recovery_admin user method. If you haven't already reviewed the recovery admin documentation, I'd take a look at the document here.
They do have instructions for restoring rights for creating administration user for older versions, but I haven't used these in a long time, and I couldn't tell you if they work on the later versions of Jira.
As always, before making any database changes, make sure that your instance is down, and you've taken a backup of the database to be able to revert any changes you make.
Thanks for your Email!
I tried the below steps to login with recovery_admin with Jira123 as password in Jira, but login failed with username and password is not correct.
1. Stop Jira with stop-jira.sh
2. Edit JVM_SUPPORT_RECOMMENDED_ARGS="-Datlassian.recovery.password=Jira123"
3. Start Jira with start-jira.sh
Can you please help?
PFB the logs. Can you please help me? Can we connect in WebEx/Teams meeting to check this issue?
2021-03-01 19:38:56,067 ajp-nio-8009-exec-7 anonymous 1178x125x1 um8mq0 126.96.36.199 /rest/gadget/1.0/login The user 'recovery_admin' has FAILED authentication. Failure count equals 14
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events