Equivalent option of mysqlpump --users in mysqldump utility

MySQL & MariaDB Percona Server for MySQL 8.0
1

Since mysqlpump utility will be deprecated in the future releases, what is the equivalent option of mysqlpump --users in mysqldump utility to take the dump of grant table contents as logical definitions in the form of CREATE USER and GRANT statements in 8.0.33-25 and higher

Is there any option to take the dump of ONLY grant table contents as logical definitions in the form of CREATE USER and GRANT statements and and suppress all database dumping in 8.0.33-25 and higher?

An early reply is highly appreciated.

Thanks
Ramasamy

2

@Ramasamy

3

When I use the pt-show-grants, I am getting the following error:

pt-show-grants -uroot --ask-pass --drop > /tmp/ptshowgrants-all-users_privileges-timestamp.sql
Enter password: DBI connect(‘;;mysql_read_default_group=client’,‘rnarayanasamy’,…) failed: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /bin/pt-show-grants line 1367.

4

Also, does pt-show-grants support login-path method to avoid entering the password?

5

Ensure you have the MySQL 8 client package installed, and the latest version of pt-show-grants and DBD::MySQL

6

Thanks a lot Mathhew. Appreciate it.

After updating the latest perl package, it is working. However, we would like to know if pt-show-grants support login-path method to avoid entering the password.

An early reply is highly appreciated.

Thanks
Ramasamy