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
>
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? /bugs.launchpad .net/bugs/ 983282 ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+ ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+ 1CD007C0144CAE4 BBF3BF45EB9F' | .`ACCOUNT` TO ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+ 1CD007C0144CAE4 BBF3BF45EB9F' ; .`ACCOUNT` TO enterprise- gpl-log MySQL /bugs.launchpad .net/percona- toolkit/ +bug/983282/ +subscriptions
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https:/
>
> 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
> '*8BC8517760BD5
> | GRANT SELECT, SELECT (WTN, AccountNum) ON `custcare`
> '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
> '*8BC8517760BD5
> GRANT AccountNum), SELECT, SELECT (WTN ON `custcare`
> 'WTN_Lookup'@'%';
>
>
> The results are identical when running mk-show-grants.
>
> MySQL version: Server version: 5.0.56sp1-
> Enterprise Server (GPL)
> Percona toolkit version: 2.0.3
>
> To manage notifications about this bug go to:
> https:/
>
--
Jim Lyons
Database administrator / Programmer