Information Technology Reference
In-Depth Information
How to do it…
Let's assume we use the default
mysql
command-line tool and
MySQL
as the backend
database for JIRA. If you are using a different database, you may need to change the fol-
lowing SQL statements accordingly:
1. Connect to the JIRA database with a client tool by running the
mysql -u
jirauser -p
command, where
jirauser
is the username to access the JIRA
database.
Tip
You can find JIRA's database details from the
dbconfig.xml
file located at
JIRA_HOME
.
2. Change to the JIRA database by running the
use jiradb
command, where
jiradb
is the name of JIRA's database.
3. Determine the groups that have the JIRA System Administrators global permission
with the following SQL statement:
select perm_parameter from schemepermissions where
PERMISSION=44;
4. Find users that belong to the groups returned in step 3 using the following SQL
statement, where
jira-administrators
is a group returned from step 3:
select child_name, directory_id from cwd_membership
where parent_name='jira-administrators';
5. Reset the user's password in the database with the following SQL statement, where
admin
is a user returned in step 4:
update cwd_user set credential='uQieO/
1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ=='
where user_name='admin';
6. Restart JIRA to apply the change.