If you need to disable Google Authenticator on the admin user in Security Analytics, you can follow the steps below.
These are the commands the user interface uses to disable google authenticator. When you cannot login as admin because it is not working properly, follow the procedure below.
This example is for the admin account. Change the admin name below for the username needed.
The first few lines of the output will look like this:
-[ RECORD 1 ]--------+---------------------------------------------------
id | 1
username | admin
name | control_center_admin.default_name
Note the id is 1. Use that ID for the commands below.
/x
select * from user_settings;
Output will be similar to:
user_id | name | value
---------+----------------+------------------
1 | language | eng
1 | totp | 4D2FTUY6ENOPPE5Z
1 | language | eng
1 | mime_type_view | derived
delete from user_settings where user_id=1 and name='totp';