I have a new install of crowd. There is only one user account added so far. The user has too many failed attempts so she is unable to login. Is there a way to add another admin user with MySQL commands?
Have a look through https://confluence.atlassian.com/crowdkb/restoring-passwords-to-recover-admin-user-rights-283642653.html - that's better than creating a new user, but take care to follow the "shut down crowd while running SQL". You should see the "failed attempts" in the database and can set them to 0 as well as set a new password.
You need anything more than the ability to run SQL on the database to change the password to something you know. Without a tool, you'll need to run some SQL selects to find out where to put things, but it's just command line stuff.
The failed attempts is just a counter on cwd_user, set it to zero for your admin user with an update
Alternatively, if you could open a session to the server running Crowd, you would be able to add another Crowd administrator account using a simple tool like curl and Crowd REST API (the application credentials to use are available in crowd.properties).
This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs