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
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>';
mysql> FLUSH PRIVILEGES