Initialising multiple databases inside a Docker MySQL image

databases.sh

#!/usr/bin/env bash

# ** usage **
# initialize a MYSQL_DATABASES env variable in the container with space separated db names
# e.g. MYSQL_DATABASES="foo bar"

# assumes that MYSQL_ROOT_PASSWORD and MYSQL_USER are set

function create_database() {
	local DATABASE=$1
	echo "Creating database '${DATABASE}'"
	mysql -uroot -p${MYSQL_ROOT_PASSWORD} <<-EOSQL
	    CREATE DATABASE \`${DATABASE}\`;
	    GRANT ALL ON \`${DATABASE}\`.* TO '${MYSQL_USER}'@'%';
EOSQL
}

for DATABASE in ${MYSQL_DATABASES[*]}; do
    create_database $DATABASE
done