UIM Install unable to connect to MySQL

Document ID : KB000007679
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.51MySQL 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