Generates MySQL GRANT statements for all users in a DB

generate-mysql-grants.sh

#!/bin/bash

users_hosts=`mysql -B -N -e "select user, host from mysql.user;"`
echo "${users_hosts}" | while read user_host; do
  user=`echo "${user_host}" | cut -f 1`
  host=`echo "${user_host}" | cut -f 2`
  if [ "${user}" != "root" ]; then
    grants=`mysql -N -e "show grants for '${user}'@'${host}';"`
    echo "${grants}" | while read grant; do
      echo "${grant};"
    done
  fi
done