drop many databases prefixed with 'test_'

drop_tests.sh

#!/bin/bash

#originated from http://stackoverflow.com/questions/5457286/drop-multiple-databases
#firstly you should use mysql_config_editor to set up a "login path" which the mysql command line client can then use.
#http://architects.dzone.com/articles/passwordless-command-line

DB_STARTS_WITH="test_"
MYSQL="mysql"

DBS="$($MYSQL --login-path=restore -Bse 'show databases')"
for db in $DBS; do

if [[ "$db" == $DB_STARTS_WITH* ]]; then
    echo "Deleting $db"
    $MYSQL --login-path=restore -Bse "drop database $db"
fi

done