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

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


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,

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
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,134 views 2 6
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