Skip to content

5. Connect to MySQL HeatWave

Jump to bottom
Frédéric Descamps edited this page Sep 8, 2025 · 4 revisions

You have multiple possibilities to connect to your MySQL HeatWave instance, and we will use three of them:

  1. using MySQL Shell in the command line via the compute instance
  2. using MySQL Shell for Visual Studio Code on your machine
  3. using Cloud Shell

MySQL Shell in the command line

MySQL Shell is already installed on the Compute Instance. From it, when connected in SSH, you can launch MySQL Shell and connect to the MySQL HeatWave DBSystem using its private IP.

Check the video:

05_Connect_to_MySQL_V1.mp4

MySQL Shell for Visual Studio Code

If we configure the OCI config on our machine, we can use MySQL for Visual Studio Code to connect to the MySQL HeatWave DBSystem via a bastion host.

We need to create or update our ~/.oci/config file to use a new API Key for our user.

Check the video with all the steps:

05_Connect_to_MySQL_part_2_V1.mp4

OCI Console's Cloud Shell

You can also use the Cloud Shell from the OCI Console to connect to your MySQL HeatWave DBSystem.

You need first to use an "Ephemeral private network" that uses your VCN and your private subnet:

Then you connect using the DBSystem's private IP, like in the video:

05_Connect_to_MySQL_part_3_V1.mp4

Clone this wiki locally