pt-show-grants doesn't work with NO_AUTO_CREATE_USER sql_mode

[Daniel Nichter]

Imported from http://code.google.com/p/maatkit/issues/detail?id=1203

Quoting the original:

A grant will implicitly create a user. This is what mk-show-grants uses.

mk-show-grants is used a lot to copy permissions from one server to oneother.

This however stops working if you set the NO_AUTO_CREATE_USER sql_mode.

This could be a solution:
Create a '--show-create-user' switch which will show the required 'CREATE USER 'user'@'host' IDENTIFIED BY...'

[Michael Wang (xw73)]

A temporary solution is this:

/usr/bin/pt-show-grants --ask-pass | perl -pe 's/^GRANT USAGE ON \*\.\* TO /CREATE USER /'

[Shahriyar Rzayev (rzayev-sehriyar)]

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