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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Bruno Vincent Community Leader Apr 12, 2016

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
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

71 views 1 6
Read article

Community Events

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

Events near you