A Python package to fetch a list of all users and grants from a MariaDB database and output them in a human-readable table format to the console.
Project description
mysqlgrantsdump
Description
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.
Getting Started
- 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
.
Example Usage
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
Example Output
+------------------+-----------+--------+--------+--------+--------+--------+------+-------+-------+
| 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 |
+------------------+-----------+--------+--------+--------+--------+--------+------+-------+-------+
License
mysqlgrantsdump
is released under the MIT License. See LICENSE
for more information.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mysqlgrantsdump-0.0.5.tar.gz
(3.0 kB
view hashes)
Built Distribution
Close
Hashes for mysqlgrantsdump-0.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8b06f9ac6db39202595ce5cc948a5394526095300b35702ed17e0e680633cfd1 |
|
MD5 | c6343e19a70976188a2757475a5222a4 |
|
BLAKE2b-256 | 88a2303a2e35d49a2809708c3ee2c22bef9920a5eba26fd8229360d46bd60f61 |