#!/bin/bash
echo "choose a password for the database:"
read input
echo "use xampp's version of mariadb? [y/n]"
read answer

if [[ $answer == 'y' ]] then
    mariadb="/opt/lampp/bin/mariadb"
else
    mariadb="mariadb"
fi

echo "use sudo? [y/n]"
read answer

if [[ $answer == 'y' ]] then
    sudo="sudo"
fi

echo "creating database..."
$sudo $mariadb -u root <<EOF
$(cat scripts/create_user.sql)
EOF

echo '$input'

$sudo $mariadb -u root < ./scripts/create_db.sql