Step 3: Connect

This page details step 3 of a 5-step guided walkthrough to help you get started with SkySQL.

In this step, you will connect to your SkySQL service.

Compatible Clients

Our guided walkthrough uses the MariaDB Client (mariadb), but SkySQL services are compatible with many other clients.

SkySQL Documentation includes client-specific instructions for:

Data-in-Transit Encryption

SkySQL features data-in-transit encryption between the client and the SkySQL service.

TLS 1.2 and TLS 1.3 are supported.

Connect

Whitelist your IP

SkySQL blocks access to a database service except by whitelisted IP addresses.

  1. Click on the database name to access the Service Details page.

    SkySQL Service Detail view
  2. Click on the pencil icon to the right of the "Whitelisted IP Addresses" heading to access the "Update IP Addresses" page.

    SkySQL Service IP Whitelist
  3. Click on the "Add My IP Address" link to add your public IP address, then click "Submit".

For additional information, see "IP Whitelist for Services".

Choose a Client

You can connect to your SkySQL database service once it moves from "Pending" state to "Healthy" state, and after you whitelist your IP address.

MariaDB SkySQL database services can be accessed from Linux, macOS, and Windows using a range of supported command-line and GUI clients, and connectors for many programming languages.

If you are new to MariaDB Server, we recommend choosing a GUI client like DBeaver (available for macOS and Windows).

Connect

You need a few details for client setup:

  1. Click on the database name to access the Service Details page.

    SkySQL Service Detail view

    Here you will find:

    • Fully Qualified Domain Name (host)

    • Read-Write Port (port)

  2. Once the service is in a "Healthy" state, you can click on the "Show Credentials" button to view the Temporary Login Service Credentials page.

    SkySQL Show Credentials view

    Here you will find:

    • Default user (user)

    • Default password (password)

    • Certificate authority chain (ssl-ca)

  3. Since client setup is different for each supported client and connector, client-specific instructions are provided.

  4. You can connect to your SkySQL database service once it moves from "Pending" state to "Healthy" state, and after you whitelist your IP address.

Next Step

  • This page was step 3 of 5.