Percona toolkit 3.5 issue (pt-show-grants not working)

MySQL & MariaDB MariaDB Server & Utilities
1

Installed latest percona-toolkit

Getting the following error with pt-show-grants:

pt-show-grants
DBI connect(‘;;mysql_read_default_group=client’,‘’,…) failed: Access denied for user ‘root’@‘localhost’ (using password: NO) at /usr/bin/pt-show-grants line 1367.

The following NEW packages will be installed:
percona-toolkit
0 upgraded, 1 newly installed, 0 to remove and 75 not upgraded.
Need to get 0 B/19.3 MB of archives.
After this operation, 67.1 MB of additional disk space will be used.
Selecting previously unselected package percona-toolkit.
(Reading database … 43309 files and directories currently installed.)
Preparing to unpack …/percona-toolkit_3.5.0-5.bullseye_amd64.deb …
Unpacking percona-toolkit (3.5.0-5.bullseye) …
Setting up percona-toolkit (3.5.0-5.bullseye) …
Processing triggers for man-db (2.9.4-2) …
root@prod01-dftl:~#
root@prod01-dftl:~# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3918018
Server version: 5.6.51-91.0-log Percona Server (GPL), Release 91.0, Revision b59139e

Copyright (c) 2009-2021 Percona LLC and/or its affiliates
Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> quit
Bye
root@prod01-dftl:~# pt-show-grants
DBI connect(‘;;mysql_read_default_group=client’,‘’,…) failed: Access denied for user ‘root’@‘localhost’ (using password: NO) at /usr/bin/pt-show-grants line 1367.
root@prod01-dftl:~#

1 Like
2

Resolved it by adding this to .my.cnf

[Client]
user=root
passowrd=correctpassword

1 Like
3

Hi, this is working as intended. You have to provide the credentials either as a parameter or in .my.cnf file as you did in the last message.

1 Like