Bash recipe for MySQL removing user and database

remove_user_and_database.sh

#!/bin/bash

# MySQL connection details
DB_CON_USER=""
DB_CON_PASS=""

# What to delete?
DB_NAME=""
DB_USER=""

# CREATE DATABASE
echo "DATABASES BEFORE deletion:"
echo "------------------------------------"
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "SHOW DATABASES"
echo "------------------------------------"
echo ""
echo "DROPPING DB $DB_NAME..."
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "DROP DATABASE $DB_NAME"
echo ""
echo "DATABASES AFTER deletion:"
echo "------------------------------------"
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "SHOW DATABASES" 
echo "------------------------------------"
echo ""


# CREATE USER
echo "USERS table BEFORE deletion:"
echo "------------------------------------"
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "SELECT User FROM mysql.user"
echo "------------------------------------"
echo ""
echo "DROPPING USER $DB_USER..."
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "DROP USER $DB_USER"
echo ""
echo "USERS table AFTER deletion:"
echo "------------------------------------"
mysql -u $DB_CON_USER -p$DB_CON_PASS -e "SELECT User FROM mysql.user"
echo "------------------------------------"
echo ""

echo "DONE!"