This is still actively in development and may not work properly until v1.0.0 release.
mysqlgrantsdump is a command-line tool that allows you to dump a list of all MySQL users and their grants. It connects to a MySQL database and retrieves the users and their associated permissions, and outputs them in a table format using the prettytable module.
- Install the required dependencies by running
pip install -r requirements.txt - Run the tool using the following command:
python mysql_grants_dump.py [OPTIONS] - The available options are as follows:
-H, --host: The MySQL database host name or IP address. Default islocalhost.-u, --user: The MySQL database user name. Default isroot.-d, --database: The MySQL database name.-P, --port: The MySQL database port number. Default is3306.
pip install mysqlgrantsdumpFrom pip
mysqlgrantsdump -u root -p # Connects default to localhost for host.From source
pip install -r requirements.txt
cd path/to/src
mysqlgrantsdump.py -u root -p+------------------+-----------+--------+--------+--------+--------+--------+------+-------+-------+
| User | Host | Select | Insert | Update | Delete | Create | Drop | Grant | Super |
+------------------+-----------+--------+--------+--------+--------+--------+------+-------+-------+
| andrewhoward | % | N | N | N | N | N | N | N | N |
| carsonlisa | % | N | N | N | N | N | N | N | N |
| dsmith | % | N | N | N | N | N | N | N | N |
| elizabethbrown | % | N | N | N | N | N | N | N | N |
| grant03 | % | N | N | N | N | N | N | N | N |
| ilopez | % | N | N | N | N | N | N | N | N |
| jeanneconrad | % | N | N | N | N | N | N | N | N |
| johngray | % | N | N | N | N | N | N | N | N |
| joshuawhitaker | % | N | N | N | N | N | N | N | N |
| kimolivia | % | N | N | N | N | N | N | N | N |
| krystal52 | % | N | N | N | N | N | N | N | N |
| larry00 | % | N | N | N | N | N | N | N | N |
| monicaadams | % | N | N | N | N | N | N | N | N |
| rodrigueznicole | % | N | N | N | N | N | N | N | N |
| uhernandez | % | N | N | N | N | N | N | N | N |
| mysql.infoschema | localhost | Y | N | N | N | N | N | N | N |
| mysql.session | localhost | N | N | N | N | N | N | N | Y |
| mysql.sys | localhost | N | N | N | N | N | N | N | N |
| root | localhost | Y | Y | Y | Y | Y | Y | Y | Y |
+------------------+-----------+--------+--------+--------+--------+--------+------+-------+-------+mysqlgrantsdump is released under the MIT License. See LICENSE for more information.