The above all settings you were mentioned are fine. But below are the Errors I found on log.
WARNING agent Cmd fail: Reply[Cmd:Explain Error:‘cmd ‘Explain’ for subsystem ‘mysql’ failed: Error 1345: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table’ Id:e274d5ca-0c84-4557-7225-8c9b1f936132]
WARNING qan-analyzer-mysql-757a86ea-worker Interval out of sequence: got 1, expected 113
ERROR agent Executable file not found in $PATH
WARNING agent Cmd fail: Reply[Cmd:GetServerSummary Error:‘Executable file not found in $PATH’