mysql probe - Access Denied for user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Configuring remote mysql connection through the mysql probe.

Using TCP connection to default port 3306
Clicking the 'Test' connection results in:

Access denied for user '[email protected]' (using password YES)

Environment

Release : 9.1.0

Component : UIM MYSQL

Resolution

MySQL uses reverse DNS lookup.
This may need setting up in the environment depending on the MySQL configuration.

This needs to be configured for the user to be able to access MySQL.

Reference the MySQL documentation for how client connections are established.

https://dev.mysql.com/doc/refman/5.7/en/host-cache.html