#!/bin/sh
for U in `mysql -e "SELECT DISTINCT CONCAT(\"'\", user, \"'\",\"@\", \"'\", host, \"'\") FROM mysql.user;" | grep -v 'CONCAT('`; do echo "## grants for $U ##" ; mysql -e "show grants for $U" | grep -v "Grants for " | awk '{print $0";"}' ; done