Skip to content

Instantly share code, notes, and snippets.

@lichti

lichti/mysql-export-grants.md

Created November 19, 2015 04:20
Show Gist options
  • Save lichti/980608ce53257ccddc0e to your computer and use it in GitHub Desktop.
Save lichti/980608ce53257ccddc0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-export-grants.md 
MYSQL_CONN="-uroot -ppassword"
mysql ${MYSQL_CONN} --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql ${MYSQL_CONN} --skip-column-names -A | sed 's/$/;/g' > MySQLUserGrants.sql

mysql -uroot -p -A < MySQLUserGrants.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment