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 Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

865 views 2 13
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