Wiki.js 2.0 - Disable Two Factor Authentication (2FA) via Database

Disabling 2FA via Database

2FA can be disabled manually to regain login of admin/user accounts in the case of losing the 2FA device/app via the database.

Use a tool like pgAdmin (postgres), DBeaver (mysql, mariadb), SQL Management Studio (mssql) or DB Browser for SQLite.

Connect to your DB, browse to the users table and locate your the user to disable 2FA for.

Edit the tfaIsActive column and and change the value from 1 to 0. Save the changes and you can login to your Wiki.js again.

If 2FA is re-enabled, user will be required to setup 2FA on their account the next time they login again.