incorrect (garbled) output from pt-show-grants

[Jim Lyons]

[In:Percona Toolkit Documentation]
The resuls from the pt-show-grants command are garbled for user grants select on a column in a table. For example, when running the mysql command line program I issued the command "show grants for WTN_Lookup" and got back:

+-----------------------------------------------------------------------------------------------------------+
| Grants for WTN_Lookup@% |
+-----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'WTN_Lookup'@'%' IDENTIFIED BY PASSWORD '*8BC8517760BD51CD007C0144CAE4BBF3BF45EB9F' |
| GRANT SELECT, SELECT (WTN, AccountNum) ON `custcare`.`ACCOUNT` TO 'WTN_Lookup'@'%' |
+-----------------------------------------------------------------------------------------------------------+

When I issue, from the Linux command line, the pt-show-grants command, here are the results:

pt-show-grants | grep WTN_Lookup
-- Grants for 'WTN_Lookup'@'%'
GRANT USAGE ON *.* TO 'WTN_Lookup'@'%' IDENTIFIED BY PASSWORD '*8BC8517760BD51CD007C0144CAE4BBF3BF45EB9F';
GRANT AccountNum), SELECT, SELECT (WTN ON `custcare`.`ACCOUNT` TO 'WTN_Lookup'@'%';

The results are identical when running mk-show-grants.

MySQL version: Server version: 5.0.56sp1-enterprise-gpl-log MySQL Enterprise Server (GPL)
Percona toolkit version: 2.0.3

[Baron Schwartz (baron-xaprb)]

I believe this is a duplicate of bug 866075. Can you confirm?

[Jim Lyons (jlyons4435)]

Yes - they look the same. thanks

On Tue, Apr 17, 2012 at 10:24 AM, Baron Schwartz <email address hidden> wrote:

> I believe this is a duplicate of bug 866075. Can you confirm?
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/983282
>
> Title:
> incorrect (garbled) output from pt-show-grants
>
> Status in Percona Toolkit:
> New
>
> Bug description:
> [In:Percona Toolkit Documentation]
> The resuls from the pt-show-grants command are garbled for user grants
> select on a column in a table. For example, when running the mysql command
> line program I issued the command "show grants for WTN_Lookup" and got
> back:
>
>
> +-----------------------------------------------------------------------------------------------------------+
> | Grants for WTN_Lookup@%
> |
>
> +-----------------------------------------------------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'WTN_Lookup'@'%' IDENTIFIED BY PASSWORD
> '*8BC8517760BD51CD007C0144CAE4BBF3BF45EB9F' |
> | GRANT SELECT, SELECT (WTN, AccountNum) ON `custcare`.`ACCOUNT` TO
> 'WTN_Lookup'@'%' |
>
> +-----------------------------------------------------------------------------------------------------------+
>
> When I issue, from the Linux command line, the pt-show-grants command,
> here are the results:
>
> pt-show-grants | grep WTN_Lookup
> -- Grants for 'WTN_Lookup'@'%'
> GRANT USAGE ON *.* TO 'WTN_Lookup'@'%' IDENTIFIED BY PASSWORD
> '*8BC8517760BD51CD007C0144CAE4BBF3BF45EB9F';
> GRANT AccountNum), SELECT, SELECT (WTN ON `custcare`.`ACCOUNT` TO
> 'WTN_Lookup'@'%';
>
>
> The results are identical when running mk-show-grants.
>
> MySQL version: Server version: 5.0.56sp1-enterprise-gpl-log MySQL
> Enterprise Server (GPL)
> Percona toolkit version: 2.0.3
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-toolkit/+bug/983282/+subscriptions
>

--
Jim Lyons
Database administrator / Programmer