Buy Percona ServicesBuy Now!

pt-show-grants not showing password hash <secret>

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-show-grants not showing password hash <secret>

    I am attempting to port over 100 MySQL users from one AWS RDS instance to another using pt-show-grants. The version of MySQL is 5.6.34.

    pt-show-grants -h global.XXXXXX.us-west-2.rds.amazonaws.com --user myuser --ask-pass > mysql-grants.sql

    However, the password portion is showing IDENTIFIED BY PASSWORD <secret>. This does not work when I go to import. How can I get pt-show-grants to show me the password hashes?
Working...
X