Example of Show Grants Mysql Statement:
SHOW GRANTS FOR 'root'@'localhost';
Show GRANTS FOR [email protected];
SHOW GRANTS FOR 'debian-sys-maint'@'localhost';
SHOW GRANTS FOR 'madc'@'%';
SHOW GRANTS FOR 'madc'@'10.10.10.%';
SHOW GRANTS FOR 'madc'@'10.10.10.42';
SHOW GRANTS FOR 'madc'@'127.0.0.1';
SHOW GRANTS FOR 'madc'@'localhost';
Example of Mysql Show Grants
SHOW GRANTS [
FOR user]
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();