You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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).
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nic,
I don't have access to DB Visualizer as I am working on a classified system. The link in the document is broken. Not really clear on how to use this document to reset a user password by shutting down the database and setting the failed attempts to zero.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there a document you can recommend for the SQL commands etc to make the changes?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Er, the document in my answer has all the SQL you need, including password changes and resetting the failure counts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.