setup_databases.sh

#!/bin/bash
read -p "Please input Mysql User(default is root):" user
if [ "${user}" = "" ];then
    user="root"
fi
read -p "Please input Mysql ${user}'s password(default is ''):" passwd
echo "drop database if exists valentine" | mysql --user=${user} --password=${passwd}
echo "create database valentine" | mysql --user=${user} --password=${passwd}
if [ $? -ne 0 ]; then
    exit 1
fi
(echo "use valentine"; cat vilya/databases/schema.sql) | mysql --user=${user} --password=${passwd}