Hello, All!
I install percona-server-server-8.0.13-4.1.el7.x86_64 and percona-toolkit-3.0.13-1.el7.x86_64 from official Percona yum repo.
OS CentOS 7.6
file /root/.my.cnf contains user and password configuration, command line tool mysql connect to server without problems.
But when I try to run pt-show-grants i got error message:
# pt-show-grants
DBI connect(';;mysql_read_default_group=client','',...) 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 /usr/bin/pt-show-grants line 1367.
What I am doing wrong?
How I can fix this issue and run pt-show-grants for Percona Server 8.0 ?
I try to write default-authentication-plugin=mysql_native_password
in /etc/my.cnf but this is boes not help...
File /usr/lib64/mysql/plugin/caching_sha2_password.so does not exists in file system
and does not exists in yum repositories:
# yum provides /usr/lib64/mysql/plugin/caching_sha2_password.so
No matches found
why pt-show-grants try to load this non existent file?