Failed to query events statement summary by digest select command denied to user

Percona Monitoring and Management (PMM)
, ,
1

Hello, i am getting error failed to query events_statements_summary_by digest in systemctl status pmm-agent.

  • perfschema is not running, QAN cant display the mysql query
  • I accidentally closed port 3306 for security reason, (Is this also the cause of this problem?)

failed to query events_statements_summary_by_digest: Error 1142 (42000): SELECT command denied to user ‘pmm’@‘localhost’ for
Jun 23 06:34:09 ip-172-31-24-93 pmm-agent[13257]: ERRO[2023-06-23T06:34:09.163+00:00] failed to query events_statements_summary_by_digest: Error 1142 (42000): SELECT command denied to user ‘pmm’@‘localhost’ for
Jun 23 06:34:14 ip-172-31-24-93 pmm-agent[13257]: ERRO[2023-06-23T06:34:14.177+00:00] failed to query events_statements_summary_by_digest: Error 1142 (42000): SELECT command denied to user

image
image1904×365 16.9 KB

2

Hi @Arul_Ferian_Ramadlon,

As the error here clearly hints for “access denied” errors, I’d like to know if you created users required and provided grants. If “pmm” is the user you wish to use.

Create users as follows and see if that helps:

Thanks,
K

1 Like
3

Thanks @kedarpercona , Solved :grinning:

1 Like