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 mysqlgrantsdump
From 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.