How to expert MySQL user account, with password and right permission to another MySQL server

matthewb August 27, 2020, 8:18am 10

You don’t have to do that MYSQL_CONN variable. Just put the parameters directly within your call to pt-show-grants

pt-show-grants -uroot -pmypassword &gt;mysqlusegrants.sql

Topic		Replies	Views
how to migrate MySQL user + password + permission from old MySQL to a newer mysQL Percona XtraDB Cluster 8.x community , mysql , percona	1	4294	August 11, 2020
Reinstall MySQL and Preserve All MySQL Grants and Users Percona XtraDB Cluster 8.x community , mysql , percona	2	773	August 12, 2020
Users Credentials Percona Toolkit	0	733	November 8, 2017
Pt-show-grants with user and password file Percona XtraDB Cluster 5.x	4	1479	September 26, 2023
Equivalent option of mysqlpump --users in mysqldump utility Percona Server for MySQL 8.0	5	888	October 6, 2023