ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

UIM Install unable to connect to MySQL


Article ID: 7679


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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. 


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


UIM 8.51 or later

MySQL 5.6


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 [email protected]'%' IDENTIFIED BY '<your password>';
mysql> GRANT TRIGGER ON *.* TO [email protected]'%' IDENTIFIED BY '<your password>';
mysql> GRANT SUPER ON *.* TO [email protected]'%' IDENTIFIED BY '<your password>';