The ScaleGrid Console Developer Hub

Welcome to the ScaleGrid Console developer hub. You'll find comprehensive guides and documentation to help you start working with ScaleGrid Console as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Connect MySQL via Command Line

Once your MySQL hosting is setup at ScaleGrid, you can easily connect to your new deployment using a shell terminal and your command line syntax. Follow these instructions to connect via the command line interface (CLI):

Get the MySQL Command Line Client

SSH Access

The MySQL client is available on the instances that your database cluster is hosted on. If you have SSH access to the underlying instances, you can access the MySQL client available on them.

Remote Connection to your MySQL Deployment from Linux Hosts

Download and install the MySQL command line client on your Linux host by selecting a suitable platform and version (GA release of 5.7 series) from the Download MySQL Community Server page. Specifically, you need to install the mysql-community-client package and any dependent packages.

Remote Connection to your MySQL Deployment from Windows Hosts

Download and install the MySQL command line client on your Windows host by downloading MySQL Workbench for Windows. Thus will also install the MySQL command line client which can be found in the workbench installation folder.

Connecting from the MySQL Command Line

Here's what you need to connect your MySQL deployment using the CLI:

  • User credentials - Follow the steps to create a new MySQL database user if you haven't already created one.
  • For SSL enabled deployments - If you would like to verify the server CA certificate, you will need the SSL CA certificate file. It is available on the Overview tab of your Cluster Details page under the SSL Certificate section as shown below:

The command line syntax for connecting to the MySQL deployment using the admin user credentials is provided on the ScaleGrid console under the Overview tab:

In general, the command line syntax is built in the following format:

mysql -u [username] -pā€™[password]ā€™ -h [host] -P 3306

In this example, we use the credentials of user 'testuser' to connect:

mysql -u testuser -p -P 3306 -h

Here's an example of a Connection String for the master of a replica set with SSL:

mysql -u sgroot -p -P 3306 -h --ssl-mode=VERIFY_CA --ssl_ca=<Path to ca.pem file>

The SSL CA certificate file pointed to in the ssl_ca argument above is the aforementioned SSL CA certificate file. Please note that if you do not require the verification of the server CA certificate, you do not need to specify the ssl-mode and ssl-ca arguments above, and the MySQL client by default connects with SSL enabled.

Connect MySQL via Command Line

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.