5.5.5 Connecting to a DB System With a PrivateLink

Connect to a DB System in HeatWave on AWS with a PrivateLink using standard MySQL clients and connectors.

This task requires the following:

• A DB System in HeatWave on AWS.
• A correctly configured PrivateLink. See Creating a PrivateLink.
• An EC2 compute instance in the same VPC as the private endpoint.
• HeatWave Certificate Authority certificate. See Enabling Host Name Identity Verification.

Do the following to connect to a DB System with a PrivateLink:

1. Login to the EC2 instance. See Connect to your Linux instance.
2. Use a MySQL client to access the DB System.

   mysql -h <hostname> -u <username> -p <password> --ssl-mode VERIFY_IDENTITY --ssl-ca
         <ca-file>

   • <hostname>: Specify the hostname of the PrivateLink.
   • <username>: Specify the username of the administrator.
   • <password>: Specify the password of the administrator.
   • <ca-file>: Specify the name of the HeatWave Certificate Authority certificate.

You are now connected to a DB System in HeatWave on AWS over a PrivateLink.