18 lines
535 B
Bash
18 lines
535 B
Bash
#!/bin/sh
|
|
set -e
|
|
|
|
DB_NAME="${DB_MYSQLDB_DATABASE:-n8n}"
|
|
DB_USER="${DB_MYSQLDB_USER:-n8n}"
|
|
DB_PASS="${DB_MYSQLDB_PASSWORD:-n8npass}"
|
|
|
|
echo "[init] creating n8n database '$DB_NAME' and user '$DB_USER'..."
|
|
|
|
mysql -u root -p"$MARIADB_ROOT_PASSWORD" <<SQL
|
|
CREATE DATABASE IF NOT EXISTS \`${DB_NAME}\` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
CREATE USER IF NOT EXISTS '${DB_USER}'@'%' IDENTIFIED BY '${DB_PASS}';
|
|
GRANT ALL PRIVILEGES ON \`${DB_NAME}\`.* TO '${DB_USER}'@'%';
|
|
FLUSH PRIVILEGES;
|
|
SQL
|
|
|
|
echo "[init] n8n DB/user ready."
|