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 vote

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.

0 vote
Bruno Vincent Community Champion 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).

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published Friday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

51 views 0 3
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot