Find all MySQL databases using InnoDB engine

To find all MySQL database using InnoDB MySQL engine, run

mysql -N mysql -e "SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';" | cut -d" " -f2 | sort | uniq

MySQL