If you use MySQL Shell for Visual Studio Code, using a bastion
host is the easiest method to connect to a MySQL HeatWave DB
Instance on OCI.
If you already have a connection setup using a bastion to host,
you may experience the same problem as me, MySQL Shell complains
about an invalid fingerprint detected:
This error has nothing to do with the fingerprint of your user
OCI Key. The problem is related to the key of your bastion host
as you can see in the output window:
This happens if you have changed your bastion host for example.
To resolve the problem, remove the current ssh host key for the
bastion host stored in your
$ ssh-keygen -R "host.bastion.us-ashburn-1.oci.oraclecloud.com"
Use the name of your bastion host of course.
When done, it’s already fixed, you can connect back to your MySQL
HeatWave DB Instance using MySQL Shell …[Read more]