Setting up MySQL Heatwave Always FREE on OCI - Final Setup - Connecting to MySQL Heatwave

Connecting to Oracle MySQL HeatWave Using MySQL Workbench: A Step-by-Step Guide

Oracle MySQL HeatWave is a powerful tool that brings real-time analytics capabilities to your MySQL database. Connecting to MySQL HeatWave using MySQL Workbench is straightforward and enhances your ability to manage and interact with your database. Here's a step-by-step guide to get you started:

Step 1: Create a Windows Compute Instance in OCI

• Sign In to OCI: Log in to your Oracle Cloud Infrastructure (OCI) account.
• Navigate to Compute: Go to Compute -> Instances -> Create Instance.
• Configure Instance: Choose the appropriate shape and operating system (Windows). Provide a name for the instance.
• Networking: Configure the network settings, including the VCN and subnet.
• Launch Instance: Click Create to launch the instance.

Step 2: Set Up MySQL Workbench on the Windows Compute Instance

• Connect to Instance: Use Remote Desktop to connect to your newly created Windows Compute instance.
• Download and Install: Download MySQL Workbench from the official MySQL website on the instance and install it.
• Launch: Open MySQL Workbench on the instance.

Step 3: Retrieve Connection Details

• Sign In to OCI: Log in to your Oracle Cloud Infrastructure (OCI) account.
• Navigate to DB Systems: Go to Database -> DB Systems.
• Select Your DB System: Find and select the MySQL HeatWave DB system you created.
• Note the Endpoint and Port: Copy the endpoint and port number listed for your MySQL HeatWave instance.

Step 4: Create a New Connection in MySQL Workbench

• Open the MySQL Connections Manager: Click on the + icon next to MySQL Connections to open the Setup New Connection window.
• Connection Name: Enter a name for your connection (e.g., "MySQL HeatWave").
• Hostname: Paste the endpoint you copied from OCI.
• Port: Enter the port number you noted (default is 3306).
• Username: Enter the admin username you set up when creating the MySQL HeatWave instance.
• Password: Click on Store in Vault... to save your password securely.

Step 5: Test the Connection

• Click Test Connection: Click the Test Connection button to ensure your settings are correct.
• Verify Success: If the connection is successful, you'll see a confirmation message. If not, double-check your endpoint, port, username, and password.

Step 6: Connect to MySQL HeatWave

• Save the Connection: Click OK to save your connection settings.
• Open the Connection: Click on your newly created connection to open it.
• Manage Your Database: You can now manage and interact with your MySQL HeatWave database directly from MySQL Workbench!

Congratulations!! You have now successfully configured MySQL Heatwave and connected to it using MySQL Workbench on a OCI Compute instance of Windows!!

Have a great weekend!