pt-toolkit tools ( like pt-show-grants , pt-archiver )

MySQL & MariaDB Percona Server for MySQL 8.0
1

pt-toolkit tools ( like pt-show-grants , pt-archiver ) is unable to connect to GCP MySQL instance, getting access denied

  • pt-toolkit tools ( like pt-show-grants , pt-archiver ) is unable to connect to GCP MySQL instance, getting access denied
  • user has required access and able to check show create user or other operations using ( mysql -h host -u user -p)

User has following grants:

GRANT PROCESS, SHOW DATABASES ON . TO test@%
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, ALTER, LOCK TABLES ON . TO test@%


Below is the error, tried with SSL cert keys as well but still getting the same error

/usr/bin/pt-show-grants --user=test --ask-pass --host=<host-IP>Enter password: DBI connect(';host=<host-IP>;mysql_read_default_group=client','test',...) failed: Access denied for user 'test'@'ip' (using password: YES) at /usr/bin/pt-show-grants line 1367.
2

I hope you mean here that you tried to login with same MySQL user using MySQL client correct?
If not then, you can try and see if you can login using MySQL client.

Also check which authentication plugin is the user using,

select user,host,plugin from mysql.user where user='test';

Check which version of percona toolkit are you using?
and also the version of perl-DBD.