#!/bin/bash

mygrants() {
	mysql -B -N $@ -e "SELECT DISTINCT CONCAT(
	'SHOW GRANTS FOR \'', user, '\'@\'', host, '\';'
	) AS query FROM mysql.user" | \
	mysql -r $@ | \
	sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
}

mygrants --host=localhost --user=root --password=secret