SingleStoreDB Cloud Endpoints

An endpoint is a URL used to connect with SingleStoreDB Cloud workspaces. The SingleStoreDB Cloud endpoints are available on the Cloud Portal. Once logged in, select your workspace, and select the Connect button for additional connection information.

Then, access SingleStoreDB Cloud at the available endpoints with SQL clients and/or development tools.

Note

When using a third-party SQL client or development tool, you must first add a database user to log into a SingleStoreDB Cloud database.

Connect to SingleStoreDB Cloud via TLS/SSL

To establish an encrypted connection from a stand-alone SQL client, you need a TLS/SSL public certificate. This certificate ensures that clients without a valid certificate are not allowed to connect to your workspace. This CA certificate can also be used to verify the identity of each workspace host. Download the TLS/SSL certificate from the Cloud Portal. Install the certificate via the instructions provided at How Do I Install a Certificate?.

For example, using the MySQL command line (CLI) client, you can connect to the SingleStoreDB Cloud endpoints using the singlestore_bundle.pemcertificate file. The .pem file enables support for encrypted connections. Include the --ssl-mode=VERIFY_CA option to verify the certificate.

Note: Include the --ssl-mode=REQUIRED option to establish a secure connection in older versions of the MySQL client, even when the --ssl-ca option is specified.

mysql -u admin -p -h <endpoint-host> -P 3306 --default-auth=mysql_native_password --ssl-ca=./singlestore_bundle.pem --ssl-mode=VERIFY_CA

See Connect to SingleStoreDB Cloud using TLS/SSL topic for more information.

Last modified: June 29, 2023

Was this article helpful?