#!/bin/bash

USER="myuser"
PASSWORD="mypassword"

tables=`mysql --user=$USER --password=$PASSWORD -e "SELECT CONCAT(table_schema,'.',table_name) FROM information_schema.tables WHERE table_schema NOT IN ( 'information_schema', 'performance_schema', 'mysql' );"`

for table in $tables; do
  echo $table
  `mysql --user=$USER --password=$PASSWORD -e "ALTER TABLE $table ENGINE=MyISAM;"`
done