How to reset an administrator's account?
Should you ever lose your phone, U2F device or access to your one-time secret password, we provide two possible solutions to reset an administrator account:
1 Solution. Another administrator may log in and reset the 2FA settings for the colleague using instructions here.
2 Solution. Reset 2FA settings directly by accessing the database:
Step 1. Connect to your database using a database management tool as described in the Database connection fields.
Step 2. Identify the Auth2FA table in your database. This table is named AUTHPLUGIN_Auth2FA.
Step 3. Execute SQL script where the user is your username in Jira:
DELETE FROM PUBLIC.AUTHPLUGIN_Auth2FA WHERE userid IN (SELECT ID FROM APP_USER WHERE USER_KEY = 'user');