mysql: Backup your user privileges

1 · Benjamin Cane · Sept. 15, 2011, 8:01 p.m.
While I am sure there are multiple ways to do this and some probably easier here is a way to backup your mysql user privileges to a CSV file. First you will need to get to the mysql cli. # mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 35083 Server version: 5.0.51a-24+lenny3 (Debian) Type 'help;' or 'h' for help....