Step 4: Connect to a DB Instance Over a Public Network

GaussDB(for MySQL) is fully compatible with the MySQL protocol. Therefore, you can connect to a DB instance through a common connection or an SSL connection. SSL connections are encrypted.

Prerequisites

  1. Bind an EIP to the target DB instance and configure security group rules.

    1. Bind an EIP to the target DB instance.

      For details about how to bind an EIP, see Step 2: Bind an EIP.

    2. Obtain the IP address of the local device.

    3. Configure security group rules.

      Add the IP address and port obtained in 1.b to the inbound rule of the security group.

      For details about how to configure a security group rule, see Step 3: Configure Security Group Rules.

    4. Run the ping command to check the connectivity between the local device and the DB instance.

  2. Use a database client to connect to the DB instance.

    You can use a database client to connect to the DB instance in the Linux or Windows OS.

    • In the Linux OS, you need to install a MySQL client on the ECS. It is recommended that you download a MySQL client running a version later than that of the DB instance.

      For details about how to obtain and install the MySQL client, see How Can I Install the MySQL Client?

    • In the Windows OS, you can use any common database client to connect to the DB instance in a similar way.

      The database client MySQL-Front is used as an example in Using MySQL-Front to Connect to a DB Instance.

Using MySQL-Front to Connect to a DB Instance

  1. Start MySQL-Front.

  2. In the displayed dialog box, click New.

    **Figure 1** Connection management

    Figure 1 Connection management

  3. Enter the information of the DB instance to be connected and click Ok, as shown in Figure 2.

    **Figure 2** Adding an account

    Figure 2 Adding an account

    Table 1 Parameter description

    Parameter

    Description

    Name

    Database connection task name. If you do not set this parameter, it will be the same as that configured for Host by default.

    Host

    EIP bound to the target DB instance. To obtain this parameter, go to the Basic Information page of the DB instance. The EIP can be found in the Public IP Address (EIP) field in the Network Information area.

    Port

    Private network port of the DB instance.

    User

    Name of the user who accesses the DB instance. The default user is root.

    Password

    Password of the DB instance account.

  4. In the displayed window, select the connection that you have created in Figure 3 and click Open.

    If the connection information is correct, the DB instance is successfully connected.

    **Figure 3** Opening a session

    Figure 3 Opening a session

    Note

    If the connection fails, ensure that preparations have been correctly made in Prerequisites and try again.

Using SSL to Connect to a DB Instance

  1. Log in to the management console.

  2. Click image1 in the upper left corner and select a region and a project.

  3. Click Service List. Under Database, click GaussDB.

  4. In the DB Instance Information area on the Basic Information page, click image2 in the SSL field to download the root certificate or certificate bundle.

  5. Import the root certificate to the Linux OS on the ECS.

    For details, see How Can I Import the Root Certificate to a Windows or Linux OS?

  6. Connect to a DB instance. The Linux OS is assumed in this example.

    mysql -h <hostName> -P <port> -u <userName> -p --ssl-ca=<caName>

    Table 2 Parameter description

    Parameter

    Description

    <hostName>

    Host IP address of the target DB instance to be connected. To obtain this parameter, go to the Basic Information page of the DB instance. The EIP can be found in the Public IP Address (EIP) field in the Network Information area.

    <port>

    Database port. To obtain this parameter, go to the Basic Information page of the DB instance. The database port can be found in the Database Port field in the Network Information area.

    <userName>

    Username of the GaussDB(for MySQL) database administrator account. The default username is root.

    <caName>

    SSL certificate file name, which should be stored in the same directory where the command is executed.

    For example, to connect to a DB instance through an SSL connection as user root, run the following command:

    mysql -h 10.16.0.31 -P 3306 -u root -p --ssl-ca=ca.pem

    Enter the password of the database account as prompted:

    Enter password:

    Note

    If the connection fails, ensure that preparations have been correctly made in Prerequisites and try again.

last updated: 2024-05-20 01:11