Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,132
Community Members
 
Community Events
176
Community Groups

how to add admin user to crowd using mysql commads

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?

2 answers

0 votes

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).

0 votes

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.

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 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

Is there a document you can recommend for the SQL commands etc to make the changes? 

 

Er, the document in my answer has all the SQL you need, including password changes and resetting the failure counts.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events