UIM Install unable to connect to MySQL

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Having installed MySQL on the same host that I am attempting to install UIM I find that when I reach the Database Configuration stage of the UIM installation I get an error:

"Failed to connect to database with provided field values. Recheck fields for accuracy. Host <hostname> is not allowed to connect to the MYSQL server."

I can see port 3306 is listening.

I have tried disabling the Windows firewall but still get the same error. 

Environment

UIM 8.51 or later

MySQL 5.6

Cause

This problem can occur if you are trying to use a MySQL user with restricted host configuration.

Resolution

Your database administrator can advise on the best approach for the creation/configuration of the user. Here's a sample MySQL code that updates the user configuration and excludes any host restrictions for this user:

mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD("<your password>") where User = 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '<your password>';
mysql> GRANT TRIGGER ON *.* TO root@'%' IDENTIFIED BY '<your password>';
mysql> GRANT SUPER ON *.* TO root@'%' IDENTIFIED BY '<your password>';
mysql> FLUSH PRIVILEGES