summaryrefslogtreecommitdiff
path: root/ghost/mysql-init-script/create-multiple-databases.sh
blob: 6b0d32ea549176e1b42a696e5269690a347b8bc5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
#!/bin/bash

set -e
set -u

if [ -n "$MYSQL_MULTIPLE_DATABASES" ]; then
  echo "Creating multiple databases: $MYSQL_MULTIPLE_DATABASES"

  for db in $(echo "$MYSQL_MULTIPLE_DATABASES" | tr ',' ' '); do
    echo "Creating database: $db"
    mysql -u root -p"$MYSQL_ROOT_PASSWORD" <<-EOSQL
      CREATE DATABASE IF NOT EXISTS \`$db\`;
      GRANT ALL ON \`$db\`.* TO '$MYSQL_USER'@'%';
EOSQL
  done

  echo "Multiple databases created"
fi