pt-show-grants doesn't work with NO_AUTO_CREATE_USER sql_mode
Bug #821711 reported by
Daniel Nichter
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Triaged
|
Low
|
Unassigned |
Bug Description
Imported from http://
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-
Changed in percona-toolkit: | |
importance: | Undecided → Low |
Changed in percona-toolkit: | |
status: | New → Triaged |
To post a comment you must log in.
A temporary solution is this:
/usr/bin/ pt-show- grants --ask-pass | perl -pe 's/^GRANT USAGE ON \*\.\* TO /CREATE USER /'