mygrants.sh

#!/bin/bash

# mygrants.sh
#
# This script dumps all grants for all users in MySQL as an SQL script that you can pipe back to mysql
#
# USAGE: ./mygrants.sh [command line options to mysql, e.g. login]
#

mysql -B -N $@ \
  -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS query FROM mysql.user" |
  while read cmd ; do
    echo "## ${cmd}"
    echo "${cmd}" | mysql -N $@
    echo
done