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
Waiting for fix in a future release of the Foglight Management Server.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center