Thanks for your request. I checked the official Magento requirements and I see they now officially support MySQL 8.x.
I notified our engineering team about this to update our solutions. Unfortunately, we don't know how long it will take for us to modify it. But our team will post a new message here once the solution has been upgraded and released.
In the meantime, you could use our LAMP 7.4 stack, which includes MySQL 8, and other Bitnami or external solutions to manually install Magento fitting your requirements.