I made a mistake i have 4 entries on my authy account for passbolt i thought i removed the old ones but i guess i didn’t i was wondering if there was a way to modifie the database directly and if somebody could help me i tried i cant figure out how to log into the database i went through portainer and bin bashed into the database container but when i type mysql it says its not a bash command
Can you check if you are using mariadb
, since the 10.5.something mariadb dropped the mysql
command to mariadb
so since the docker compose is using mariadb:10.11
mysql
is not there.
Once inside the database, look for your user_id
in users where username='xx@yy.zz' and active = 1 and deleted = 0;
then select * from account_settings where user_id = 'xxx';
then identify the mfa line and delete from account_settings where id = 'zzz' ;
Best regards
the compose says mariadb:10.10