mygrants!

mygrants.sh

# cool mysql grants printing function (producing proper sql) - http://serverfault.com/a/13050                                                                                                                                                  
# example:                                                                                                                                                                                                                                     
# mygrants --host=prod-db1 --user=admin --password=secret | grep rails_admin | mysql --host=staging-db1 --user=admin --password=secret                                                                                                         
mygrants()                                                                                                                                                                                                                                     
{                                                                                                                                                                                                                                              
  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;}'                                                                                                                                                                        
}