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 Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

778 views 33 5
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