summaryrefslogtreecommitdiff
path: root/mysql-setup.sh
blob: 363bddab7837bcf9f3fa3f2a0e0f1d9a97fae23f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
#!/bin/sh

echo "Initializing MySql"
. ./config
password=`grep password /home/opentox/.opentox/config/production.yaml | sed 's/\.*:password://' | tr -d ' '`
mysql -u root -p$mysql_root << EOF
  DROP DATABASE IF EXISTS $branch;
  CREATE DATABASE production;
  GRANT ALL PRIVILEGES ON production.* TO production@localhost IDENTIFIED BY "$password";
  FLUSH PRIVILEGES;
EOF