dump mysql grants into SQL compatible sytax

grants.sh

#!/usr/bin/env bash

set -o nounset                              # Treat unset variables as an error

#
# you can call this script as such if needed:
# ./grants --user="mymysqlusername" --pass="password" --host="somehost"
#
#  I much prefer .my.cnf or similar

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

#you can hardcode creds here but I don't recommend it:
#grants --user="$SrcUsername" --pass="$SrcPass" --host="$SrcHost"

#just call the function directly, note "mysql $@" above.. so you can pass extra flags here
grants

i'm using this more and more these days. nice work starkers!