mysql Probe Message: Interval processing raised an error

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After configuring a host on the mysql probe it is possible to receive the following message:
"Interval processing raised an error"
This can occur even if the server is pingable, there are no firewalls and the mysql probe test connectivity button works well.

Cause

This is typically a problem with the database permissions for the configured user.

Environment

UIM 8.5.x or later

mysql probe any version

Resolution

Granting the following permissions to the user can resolve the problem:
SELECT
SUPER
REPLICATION