This script creates a new database and a user. Useful when setting up a project.

create_new_db_user.sh

#!/bin/bash

#This script creates a new DB and an associated user with it

echo "Input the database to be created: "
read db 

echo "Input the username to be associated with the DB: "
read username

echo "Input the host (% for all the hosts): "
read host

echo "Input the password for the user: "
read pwd

mysql -u <ROOT USERNAME> -p<ROOT PASSWORD> << HERE

create database $db ;
create user '$username'@'$host' identified by '$pwd';
grant all on $db.* to '$username'@'$host';
flush privileges; 
HERE