How to disable 2FA for Confluence: U2F & TOTP plugin by directly accessing the database?

In case you change secure connection (HTTPS) to unsecure (HTTP), lose your access or other cases follow next steps:

Step 1. Connect to your database using a database management tool with the fields, as described in the Database connection fields.

 

Step 2. Execute the SQL script:

DELETE FROM BANDANA WHERE BANDANAKEY = 'authEnable';