test.sh

domName=insurance
username=administrator
pass=administrator
echo "Creating database..."
echo "DROP DATABASE IF EXISTS wordpress_$domName;"
mysql -e "DROP DATABASE IF EXISTS wordpress_$domName;"
echo "CREATE DATABASE wordpress_$domName;"
mysql -e "CREATE DATABASE wordpress_$domName;"

dbUserName="${username}_${domName}"
mysql -e "DROP USER IF EXISTS '$dbUserName'@'localhost';"
echo "DROP USER IF EXISTS '$dbUserName'@'localhost';"
mysql -e "CREATE USER '$dbUserName'@'localhost' IDENTIFIED BY '$pass'"
echo "CREATE USER '$dbUserName'@'localhost' IDENTIFIED BY '$pass'"
mysql -e "GRANT ALL PRIVILEGES ON wordpress_$domName.* TO $dbUserName@localhost;"
echo "GRANT ALL PRIVILEGES ON wordpress_$domName.* TO '$dbUserName'@'localhost';"
mysql -e "FLUSH PRIVILEGES;"