Dump all users and priviledges on MySQL server

dump-users.sh

#!/bin/sh

mysql "$@" -AN <<'SQL'

SELECT CONCAT('CREATE USER ', QUOTE(user), '@', QUOTE(host), ' IDENTIFIED WITH ', QUOTE(plugin), ' AS ', QUOTE(authentication_string), ';')
  FROM mysql.user WHERE user<>'' AND host<>''
  ORDER BY user, host
;

SQL

mysql "$@" -AN <<'SQL' | mysql "$@" | sed 's/$/;/;/^Grants for /d'

SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
  FROM mysql.user WHERE user<>'' AND host<>''
  ORDER BY user, host
;

SQL