Foglight installer fails when using a MySQL 8 backend (4371095)

When installing Foglight using an external MySQL 8 database the following error can be seen when the installer attempts to create the database:

ERROR   [main] com.quest.nitro.installanywhere.database.FoglightDatabaseConfigurator - Execute statement GRANT SELECT ON `mysql`.`proc` TO 'user'@'%' failed.
java.sql.SQLSyntaxErrorException: (conn=16) Table 'mysql.proc' doesn't exist

WORKAROUND

When performing the installation, select the option to Manually create the repository database and then remove the following lines from the mysql_create_db.sql script before running to create the database.

GRANT SELECT ON `mysql`.`proc` TO 'user'@'%';
GRANT SELECT ON `mysql`.`proc` TO 'user'@'localhost';

STATUS

Fixed in the 7.3 release of the Foglight Management Server.