Skip to content

Instantly share code, notes, and snippets.

@deviousway

deviousway/mysql_export_users_with_privileges_and_password.txt

Created August 5, 2018 10:23
Show Gist options
  • Save deviousway/0488afcd3beb7c44412795b865594bbd to your computer and use it in GitHub Desktop.
Save deviousway/0488afcd3beb7c44412795b865594bbd to your computer and use it in GitHub Desktop.
Download ZIP
mysql export users with privileges and password
Raw
mysql_export_users_with_privileges_and_password.txt
#on old
mysqldump -udebian-sys-maint -p$PASSWORD mysql user > user_table_dump.sql
#on new
mysql -udebian-sys-maint -p$PASSWORD mysql < user_table_dump.sql
#login to mysql
mysql> flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment