Perguntas Frequentes

#!/bin/bash

DB_STARTS_WITH="icondev"
MUSER="root"
MPWD="XXXXXXXXX"
MYSQL="mysql"

DBS="$($MYSQL -u $MUSER -p"$MPWD" -Bse 'show databases')"
for db in $DBS; do

if [[ "$db" == $DB_STARTS_WITH* ]]; then
echo "Deleting $db"
$MYSQL -u $MUSER -p"$MPWD" -Bse "drop database $db"
fi

done