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.

Environment

UIM 8.5.x or later

mysql probe any version

Cause

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

Resolution

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