Adding A User To The "System-Administrators" Group



I just recently completed the local install of Confluence, and I'm running into problems setting up our SMTP server for notifications. The issue is due to not having System Administration access (Currently no account is listed as having System Administrator access).


Are there any queries that I can run against the DB to verify that no on is in that group? If no one is in the group is there a query I can run that will add an existing user to the group?

Thank you for all of the help and please let me know if more information is needed!

1 answer

1 accepted

Hello Mikael,


I tried going through this earlier, but I'm running into an issue after executing the below query.

update cwd_user set credential =
where id=1212121;

After running the query I attempt to login using username "admin" and the password "admin", but I'm receiving an incorrect password error and I'm also asked to type out a word now when attempting to log in. 

Mikael Sandberg Community Champion Oct 19, 2017

Is your Confluence instance connected to AD or are you just using an internal user directory. If you are using multiple, did you do the step where it moved the internal directory to be first?

Currently I'm just using the internal directory. It is linked to Jira Service Desk though, which is using Active Directory for authentication (not sure if this has any effect on Confluence authentication though).

Mikael Sandberg Community Champion Oct 19, 2017

The application link should not have any effect to the authentication.

When you run the query to identify the administrator now, does it show that the admin is active? And before you added the admin, was Confluence stopped?

It does show the admin as active, however I didn't stop Confluence before making the change so I'm sure that has something to do with it. 



The second link you sent me got us squared away. Thank you!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

950 views 13 11
Join discussion

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