pt-show-grants ignore switch not working

[Franck]

[ ]$ pt-show-grants --ignore ganglia,truec -h xxxx.xxx.com

-- Grants for 'ganglia'@'localhost'
GRANT PROCESS, SUPER ON *.* TO 'ganglia'@'localhost' IDENTIFIED BY PASSWORD 'xxx'

-- Grants for 'truec'@'10.%'
GRANT USAGE ON *.* TO 'truec'@'10.%' IDENTIFIED BY PASSWORD 'xxx'
GRANT ALL PRIVILEGES ON `truecardev1`.* TO 'truec'@'10.%';

[Franck (fleveneur-l)]

pt-show-grants --ignore switch does not work, --only switch does !

[Nilnandan Joshi (nilnandan-joshi)]

Confirmed with 2.2.14

nilnandan@desktop:~$ pt-show-grants --version
pt-show-grants 2.2.14
nilnandan@desktop:~$

nilnandan@desktop:~$ pt-show-grants --ignore root -hlocalhost,u=root,p=root
-- Grants dumped by pt-show-grants
-- Dumped from server Localhost via UNIX socket, MySQL 5.6.24-72.2-log at 2015-06-01 15:07:12
-- Grants for 'debian-sys-maint'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '*3568A19E0FBD049FCEE24502A2B5BBC7AAFDFA1D' WITH GRANT OPTION;
-- Grants for 'root'@'127.0.0.1'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;
-- Grants for 'root'@'::1'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;
-- Grants for 'root'@'desktop'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'desktop' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'desktop' WITH GRANT OPTION;
-- Grants for 'root'@'localhost'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
nilnandan@desktop:~$

[Josh Watts (josh-sroz)]

This appears to be a deficiency in the documentation: The --ignore option appears to only work on fully specified users:

pt-show-grants --ignore root@localhost,user@host

Counter to this, the --only argument accepts both username and username@hostname formats.

pt-show-grants --only root,user@host

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1284