6.1.4 Connecting to a DB System With a PrivateLink

Connect to a DB System in HeatWave on AWS with a PrivateLink using a MySQL clients (for example, mysqlor MySQL Shell) or MySQL Connectors.

This task requires the following:

• A DB System in HeatWave on AWS.
• A correctly configured PrivateLink. See Creating a Query PrivateLink, and knowledge of its private hostname, which is displayed as Hostname on the PrivateLink Details page and as PrivateLink Hostname on the MySQL DB System Details page in the HeatWave Console.
• A MySQL client that has network access to the same VPC as the endpoint for the PrivateLink. See Creating an Endpoint for a Query PrivateLink.
• If the MySQL client is connecting to the DB System with the VERIFY_CA or VERIFY_IDENTITY connection mode, a HeatWave Certificate Authority bundle. See Enabling Host Name Identity Verification. This is optional because the client can connect without verifying the server CA certificate or the server's identity.

Connect to DB System in HeatWave on AWS as you normally would (see Connecting from a Client), but use the PrivateLink's hostname as your hostname. For example, run a mysql client in your AWS account with the following command:

Press CTRL+C to copy
 
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 a MySQL user.
• <password>: Specify the password of the MySQL user.
• <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. If you fail to connect, see Troubleshooting a Query PrivateLink for help.

Parent topic: Deploying a Query PrivateLink