Cannot replace Confluence Admin password directly through MySQL database

Hi, I cannot login to my JIRA thus i need to recover the admin password.

I followed https://confluence.atlassian.com/display/CONF42/Restoring+Passwords+To+Recover+Admin+User+Rights

This password for 'admin' does not work, it stills stating that the password was wrong.

x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==

I am using MySQL with Confluence 5.0-m9 beta

1 answer

Hi there,

I suspect the most likely cause of this problem is actually your browser caches and not the password update, so please try clearing your browser caches and seeing whether you can then login using the "admin" password as usually this will resolve your issue. However, if the problem persists after you have cleared your browser caches please open a ticket with Support and we will investiaget this issue further for you.

All the best,
John

Hi I just tried clearing cache but it's still not working. Is it possible that because I have a JIRA link? I was able to login to confluence before I add the JIRA user link. It's not working for my confluence admin account after added the jira user authentication. how can I disable it through MySQL DB?

What does "jira link" mean? If you've configured confluence to use Jira as the list of users, then amending the confluence database is pointless because it's reading Jira.

You need to log in using a Jira account now, and if you've lost access to them, stop Jira, amend the Jira user database with the password hash, restart Jira and then log in with the Jira account and "sphere"

that's what gone wrong it kept telling me the user(admin) is wrong but i can loginto jira with the same admin account

I have the same accounts when I setup confluence. it was the user named admin and in JIRA I too setup with an initial user called admin. It was all working fine with confluence using JIRA user directory until I change my domain name. I change the base URL in jira, then i change the linked in Confluence to reflect the same URL however it stop working after that and I could not login to confluence anymore thus I have no access to the admin panel to do any changes!

So, if you can log into Jira with admin/password and you can NOT log into confluence with admin/password, then you have NOT connected confluence and told it to use Jira users. OR, the admin account in confluence does not belong to the admin (or even login) groups on confluence.

Could you go back over exactly your accounts in Confluence and work out

1. Who you are logging in as, and what rights you expect them to have

2. Where confluence is keeping it's users - internally, in Jira or somewhere else.

Ok, that's useful to know, but we really need to be 100% clear on where your user accounts are being kept.

Is confluence STILL using the Jira user directory? How is this configured? In the UI via urls, or have you pointed Confluence to Jira via a database connection?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

474 views 19 9
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