Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Show Grants Mysql Statement

Example of Show Grants Mysql Statement:

SHOW GRANTS FOR 'root'@'localhost';
Show GRANTS FOR are@10.10.10.10;
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();