nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add user without access to admin area

_Helm

Hello,

Installing Confluence I messed up and used same jira db to install, and now I have no access to jira, cannot login with any of the admin users.

There is a way to add a user or create a new one without that access?

Sorry for the inconvenience, best regards!

Accepted answers

Alexey Matveev

Hello,

Kindly have a look at this KB:

https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html

All comments

Alexey Matveev

Hello,

Kindly have a look at this KB:

https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html

_Helm

thanks for your answer, I already landed there but this sentence is failing:

<span>insert</span> <span>into</span> cwd_user <span>values</span> <span>(</span><span>999999</span><span>,</span><span>1</span><span>,</span><span>'localadmin'</span><span>,</span><span>'localadmin'</span><span>,</span><span>1</span><span>,</span><span>'2012-01-04 19:49:05-08'</span><span>,</span><span>'2012-01-04 19:49:05-08'</span><span>,</span><span>'local'</span><span>,</span><span>'local'</span><span>,</span><span>'admin'</span><span>,</span><span>'admin'</span><span>,</span><span>'local admin'</span><span>,</span><span>'local admin'</span><span>,</span><span>'localadmin@localadmin.com'</span><span>,</span><span>'localadmin@localadmin.com'</span><span>,</span><span>'uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ=='</span><span>,</span><span>NULL</span><span>,</span><span>NULL</span><span>)</span><span>;</span>

because this is missing one field.

BUT IGNORE ME, I just realized (writting this answer that) my current cwd_user schema is wrong because it is the confluence cwd_user schema, not the jira one.

Thanks so much, I'll install jira in a vm and copy from there the current schema, if it works, I'll tell if not too

_Helm

Finally we have it up and running again, thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

jira

jira-software

jira-software-server