aboutsummaryrefslogtreecommitdiffstats
path: root/moonv4/moon_db/tests/configure_db.sh
blob: bdc259fe48e4797a67e6607717f4292c28598f4e (plain)
1
2
3
4
5
6
7
8
9
#!/usr/bin/env bash

apt-get install mysql-server python-mysqldb python-pymysql

mysql -uroot -ppassword <<EOF
CREATE DATABASE moon DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON moon.* TO 'moonuser'@'%' IDENTIFIED BY 'password';
GRANT ALL ON moon.* TO 'moonuser'@'localhost' IDENTIFIED BY 'password';
EOF