Enable the general query log for a MySQL/MariaDB docker container and tail it. Disable the general query log on exit.

log_mysql_queries.sh

#!/bin/sh

CONTAINER=appwrite-mariadb
if [ ! -z "$1" ]; then
    CONTAINER=$1
fi

docker exec -it $CONTAINER sh -c 'mysql -uroot -p$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE -e "SET GLOBAL general_log=1"'
docker exec -it $CONTAINER sh -c 'tail -f /var/lib/mysql/$HOSTNAME.log'
docker exec -it $CONTAINER sh -c 'mysql -uroot -p$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE -e "SET GLOBAL general_log=0"'