when I do :
pt-show-grants > grants.sql
it shows error
DBI connect(‘;;mysql_read_default_group=client’,‘’,…) failed: Plugin caching_sha2_password could not be loaded: lib64/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/bin/pt-show-grants line 1367.
what is that meant ? seems need to connect to mysql first?
what is the full command to run it?
Have you updated to the latest version of Percona Toolkit? It looks like you might be using an older version to connect to MySQL 8.
I did!