All Products
Search
Document Center

Connect to DLA through MySQL CLI tools

Last Updated: May 13, 2019

DLA supports Java Database Connectivity (JDBC) that is compatible with MySQL. You can use a MySQL CLI tool to connect to DLA through JDBC.

Prerequisites

  • The MySQL CLI supports MySQL 5.0 and later versions for DLA access.

    1. mysql --version
    2. mysql Ver 14.14 Distrib 5.6.38, for Linux (x86_64) using EditLine wrapper
  • You have created an endpoint to generate Address:Port. If not, create one by following the instructions provided in Create an endpoint.

Procedure

Connect to DLA without specifying a schema

  1. mysql -h<end_point_host> -P<end_point_port> -u<user_name> -p<password> -c -A

Parameter description

  • end_point_host: the host address that is used to connect to DLA. For more information about how to obtain the host address, see View endpoint information in Create an endpoint.

  • end_point_port: the port number.

  • user_name: the name of the service account for DLA access.

  • password: the password of the service account for DLA access.

After you connect to DLA, you can run use <schema> to switch to the corresponding schema.

Specify a schema to connect to DLA

  1. mysql -h<end_point_host> -P<end_point_port> -u<user_name> -p<password> <schema> -c -A

After you connect to DLA, the page of the specified schema appears. You can run select database() to view the schema information.