pt-show-grants can't work with Percona Server 8.0

89 views
Skip to first unread message

g...@ideil.com

unread,
Feb 21, 2019, 6:08:36 AM2/21/19
to Percona Discussion
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?

Reply all
Reply to author
Forward
0 new messages