How to persist database and configurations

i am experimenting with multiple MISP instances using docker compose, i have managed to connect them successfully however i am not able to persist the data base i tried adding a volume to persist /var/lib/mysql but i could not login to MISP once the containers are restarted with neither the new nor the old password

how could i persist the MISP instance after container restart?