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

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 votes
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 Sign up to answer
Community showcase
Published Monday in Jira Service Desk

Frequently Asked Questions for Jira Service Desk (AKA JSD FAQ)

Just the FAQs! Welcome to the Community, and this Focused-FAQ! Here, we've pulled together some of the most frequently asked questions associated with Jira Service Desk (JSD). We hope ...

111 views 0 11
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