Export the privileges from MySQL and import to another server

[xluffy]

Method 1 - Bash

> _my_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;}'
}

> _my_grants > users.sql

Method 2 - Percona Toolkits

> pt-show-grants > users.sql