https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
docker run -it --env-file .db.env -v /Users/tjen/dev/tjen/homeserver/tmp/firefly-iii-docker/test-db-backup:/test-db-backup -v firefly-iii-docker_firefly_iii_db:/var/lib/mysql --env MARIADB_ROOT_PASSWORD=foo --env MYSQL_RANDOM_ROOT_PASSWORD=false mariadb:lts --skip-grant-tables
docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 3c93299d33b3 mariadb:lts “docker-entrypoint.s…” 7 seconds ago Up 7 seconds 3306/tcp romantic_hamilton
docker exec -it romantic_hamilton /bin/bash
root@3c93299d33b3:/# mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 11.4.2-MariaDB-ubu2404 mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.003 sec)
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'foo';
Query OK, 0 rows affected (0.004 sec)
MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('foo');
Query OK, 0 rows affected (0.003 sec)
MariaDB [(none)]> ^DBye
docker stop romantic_hamilton
docker run -it --env-file .db.env -v /Users/tjen/dev/tjen/homeserver/tmp/firefly-iii-docker/test-db-backup:/test-db-backup -v firefly-iii-docker_firefly_iii_db:/var/lib/mysql --env MARIADB_ROOT_PASSWORD=foo --env MYSQL_RANDOM_ROOT_PASSWORD=false mariadb:lts
docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 2da5680b9ad5 mariadb:lts “docker-entrypoint.s…” 4 seconds ago Up 4 seconds 3306/tcp pensive_fermat
docker exec -it pensive_fermat /bin/bash
root@3c93299d33b3:/#