#!/bin/bash

# settings
MYSQL=mysql


mysql_data_def=verlihub
read -p "mysql database for verlihub will ba called?($mysql_data_def)" mysql_data
[ "_$mysql_data" == "_" ] && mysql_data=$mysql_data_def
echo "mysql database is $mysql_data"

mysql_user_def=verlihub
read -p "mysql user to access $mysql_data gonna be?($mysql_user_def)" mysql_user
[ "_$mysql_user" == "_" ] && mysql_user=$mysql_user_def
echo "mysql user is $mysql_user"

mysql_pass_def=verlihub
read -p "mysql password to access $mysql_data be?($mysql_pass_def)" mysql_pass
[ "_$mysql_pass" == "_" ] && mysql_pass=$mysql_pass_def
echo "mysql pass is $mysql_pass"

mysql_host_def=localhost
read -p "mysql server will run where?($mysql_host_def)" mysql_host
[ "_$mysql_host" == "_" ] && mysql_host=$mysql_host_def
echo "mysql server will be on $mysql_host"

read -p "Do you want to prepare database? (Y/N)" rep
if [ "$rep" == 'Y' ] || [ "$rep" == 'y' ]; then
	echo Ok preparing mysql..
	echo "You probably need administrator access to mysql database"
	
	mysql_root_def=root
	read -p "mysql administrator username?($mysql_root_def)" mysql_root
	[ "_$mysql_root" == "_" ] && mysql_root=$mysql_root_def
	echo "mysql administrator is $mysql_root"
		
	mysql_this_host_def=localhost
	if [ $mysql_host != 'localhost' ]; then
		read -p "Verlihub's server as host from the mysql's scope is?" mysql_this_host
		[ "_$mysql_this_host" == "_" ] && mysql_this_host=$mysql_this_host_def
	fi;

	$MYSQL -h $mysql_host -u $mysql_root -p -e "CREATE DATABASE $mysql_data; GRANT ALL ON $mysql_data.* to $mysql_user@$mysql_this_host identified by '$mysql_pass'"
fi;


echo done
