#!/bin/bash AUTH="-u root -ppassword" echo "SELECT Concat('create database ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME NOT IN ('mysql', 'information_schema');" \ | mysql $AUTH --silent --skip-column-names echo echo "select concat('show grants for ', User, '@\\'', Host, '\\';') from user where User != 'debian-sys-maint';" \ | mysql $AUTH mysql --silent --skip-column-names \ | mysql $AUTH --silent --skip-column-names \ | sed -e 's/$/;/'