Not the answer you need?
Register and ask your own question!

What's the smallest privileges required for pt-show-grants?

leafonswordleafonsword ContributorInactive User Role Beginner
I used pt-show-grants in B machine to dump A machine's privileges,and B machine's user has select privileges to A machine,but generated file doesn't print password information ,like this:
GRANT USAGE ON *.* TO 'XXXX'@'XXXX' IDENTIFIED BY PASSWORD ;
but I run pt-show-grants in A machine using root user,then password information would be contained,like this:
GRANT USAGE ON *.* TO 'XXXX'@'XXXX' IDENTIFIED BY PASSWORD IDENTIFIED by 'XXXX' ;

So what's the smallest privileges required by pt-show-grants?

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    It seems like the minimum privilege for a user would be SELECT on mysql.*
    GRANT SELECT ON mysql.* TO 'username'@'hostname' IDENTIFIED BY 'somepassword';
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.