|Since version 8.0.18, installed Windows instances often fail with the error "Unable to connect to any of the specified MySQL hosts.."
The bug is documented at ...
There is as not a known fix. Best known workaround: install MySQL Installer 8.0.17 from https://downloads.mysql.com/archives/community/, use it to install MySQL Server and to update the catalog but do not use it to upgrade the installer itself when it prompts you to do so.
Last updated 8 Jun 2020