#!/bin/sh

read -p "Execute query: " q

read -p "Enter username: " dbuser
read -p "Enter password: " -s dbpass
echo ""

callAction()
{
  echo "Executing query on $db"

  mysql -u$dbuser -p$dbpass -D $db -e "$q"
}

for db in $(echo "show databases" | mysql -u$dbuser -p$dbpass | grep -v Database); do
  if [[ $db != information_schema ]] && [[ $db != adminv2 ]] && [[ $db != proftpd ]] && [[ $db != mysql ]] && [[ $db != nowcom_nl ]] && [[ $db != nucommunity_nu ]] && [[ $db != clubworkx ]] ; then
    callAction
  fi
done