Error while using pt-query-digest processlist

[Viswanatha Reddy]

am new to percona when am i using below one am getting below error so can any one help here.

pt-query-digest --processlist h=localhost --interval=0.01 --output=slowlog

output Error :-

-----------------

DBI connect(';host=localhost;mysql_read_default_group=client','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/pt-query-digest line 1001

Thanks,

Viswanatha K

[Roel Van de Paar]

Hi Viswanatha,

Please try using --user and --password

https://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html

[Lee Parayno]

Since you do not have anonymous users or allow your root user to connect without a password “(using password: NO)" configured, you need to specify the username and password for your MySQL instance.

pt-query-digest —user <user> —password <passord> …….

Lee Parayno

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.