MYSQL_MISP_PASSWORD not being applied correctly from Compose

[arnydo]

When specifying the MYSQL_MISP_PASSWORD via Docker-Compose.yml, the password is not set correctly in database.php file. However, it is correctly set in MySQL itself.

I am assuming this may be related to special characters in the password not being read correctly.

[ktneely]

I did not run into this when testing misp-docker, but now that I'm trying to replicate for production, I have this same issue, even without special characters in my docker-compose file.
The environment is set correctly, as echo $MYSQL_ROOT_PASSWORD returns the password I have set.