How to reset MFA secret token

[nexus]

1- Point to the VIP resident node in SSH
2- Login to mysql

mysql -u <user> -p

3- Select the database

use zstack;

4- Find the account you want to reset the secret token

Select uuid from AccountVO where name='<username>';

5- Find the secret associated with the user

Select secret From TwoFactorAuthenticationSecretVO Where userUuid='<uuid>';

6- Delete the secret

Delete From TwoFactorAuthenticationSecretVO Where secret='<secret>';

7- Open the login page from a fresh (incognito) webpage and follow the procedure to set up the 2FA again