Jira Internal Directory Database connection

[Abdullah Sa'D Muhammad Answar Vencapah]

Hi All,

I want to connect to the Jira Internal Directory database.
How can I connect to Jira Internal Directory with mysql or phpmyadmin?

Can you please advise me on the topic?

[Brant Schroeder · Accepted solution]

@Abdullah Sa'D Muhammad Answar Vencapah 

I would suggest using the API to connect to the internal directory.  This way you will not actually make any changes that will break your instance.  https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/user 

If you are just wanting to read the table and look at the data the table to look at is CWD_USER.  https://developer.atlassian.com/server/jira/platform/database-user-and-group-tables/ 

If you share what you are trying to do I can provide additional information.  

[Abdullah Sa'D Muhammad Answar Vencapah]

Hi @Brant Schroeder ,

Thank you for the replied.
I want to do an bulk update of the username in jira internal directory.

[Brant Schroeder]

@Abdullah Sa'D Muhammad Answar Vencapah  take a look at this https://confluence.atlassian.com/jirakb/bulk-update-username-and-email-using-rest-api-1085440914.html