MySQL 8.x as external database fails as it does not support authentication type (4378240)

Foglight is unable to start when using MySQL 8.x as the external database; the errors in the Management Server log indicate that the connection is not using a password even though one is set in the server configuration file.

FATAL   [forge-startup] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database. Shutting down Foglight server... Check and make sure your database configuration is correct and the database server is up running.
java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'foglight'@'foglight.yourdomain.com' (using password: NO))
...
Caused by: java.sql.SQLException: Access denied for user 'foglight'@'foglight.yourdomain.com' (using password: NO)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'

Authentication plugin caching_sha2_password is not supported.

WORKAROUND

Update the Foglight database user to use the mysql_native_password authentication plugin.

STATUS

This issue was logged as defect FOG-9087 and has been fixed in the 7.3.0 and higher releases of Foglight.