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

**URL:** <https://forums.percona.com/t/percona-toolkit-3-5-issue-pt-show-grants-not-working/19470>\
**Category:** MariaDB Server & Utilities\
**Created:** [January 5, 2023, 1:50am UTC](https://forums.percona.com/t/percona-toolkit-3-5-issue-pt-show-grants-not-working/19470 "2023-01-05T01:50:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![indigo](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@indigo](https://forums.percona.com/u/indigo)\
**Post date:** [January 5, 2023, 1:50am UTC](https://forums.percona.com/t/percona-toolkit-3-5-issue-pt-show-grants-not-working/19470/1 "2023-01-05T01:50:14Z")

</div>

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:~#

---

<div class="post-metadata">

**Author:** ![indigo](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@indigo](https://forums.percona.com/u/indigo)\
**Post date:** [January 5, 2023, 2:52am UTC](https://forums.percona.com/t/percona-toolkit-3-5-issue-pt-show-grants-not-working/19470/2 "2023-01-05T02:52:58Z")

</div>

Resolved it by adding this to .my.cnf

[Client]  
user=root  
passowrd=correctpassword

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [January 5, 2023, 1:50pm UTC](https://forums.percona.com/t/percona-toolkit-3-5-issue-pt-show-grants-not-working/19470/3 "2023-01-05T13:50:35Z")

</div>

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.
