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

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

justinkjustink EntrantLegacy User Role Novice
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?

Comments

  • ahilmanbsahilmanbs Current User Role Novice

    i have same issue. pt-show-grants not showing password hash anymore.

    Any update with this issue?

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.