Updated on 2024-09-25 GMT+08:00

Using CLI to Connect to a FlexusRDS Instance

Scenarios

You can connect to your DB instance using the MySQL command-line interface (CLI) from a FlexusX instance with a MySQL client installed.

FlexusX instances and FlexusRDS instances in the same region are in the same VPC, subnet, and security group by default and can communicate with each other.

Procedure

  1. Log in to the FlexusX instance in the same region as your FlexusRDS DB instance.
  2. Download the MySQL client installation package for Linux to the FlexusX instance. The package mysql-community-client-5.7.38-1.el6.x86_64.rpm is used as an example.

    wget https://dev.mysql.com/get/mysql-community-client-5.7.38-1.el6.x86_64.rpm

    A MySQL client running a version later than that of the FlexusRDS DB instance is recommended.

  3. Install the MySQL client.

    rpm -ivh --nodeps mysql-community-client-5.7.38-1.el6.x86_64.rpm

    • If any conflicts occur during the installation, add the replacefiles parameter to the command and install the client again.

      rpm -ivh --replacefiles mysql-community-client-5.7.38-1.el6.x86_64.rpm

    • If a message is displayed prompting you to install a dependent package during the installation, add the nodeps parameter to the command and install the client again.

      rpm -ivh --nodeps mysql-community-client-5.7.38-1.el6.x86_64.rpm

  4. Run the following command on the FlexusX instance to connect to the FlexusRDS DB instance:

    mysql -h <host> -P <port> -u <userName> -p

    Example:

    mysql -h 192.168.0.1 -P 3306 -u root -p

    Table 1 Parameter description

    Parameter

    Description

    <host>

    The DB instance to be connected. You can connect to your DB instance over a private network or public network. For higher security, private network connection is recommended.

    • Private network connection (recommended): Click the DB instance name and obtain the private domain name on the Overview page.
    • Public network connection: Click the DB instance name and obtain the EIP on the Overview page. For details about how to bind an EIP to a DB instance, see Binding an EIP to a FlexusRDS Instance or Unbinding an EIP from a FlexusRDS Instance.
      Figure 1 Network information

      To connect to your DB instance through an EIP, add the EIP and port 3306 to an inbound rule of security group sg-default-smb. For details, see Adding a Security Group Rule.

      Figure 2 Adding an inbound rule

    <port>

    3306

    <userName>

    root

  5. When the following information is displayed, enter the password of user root:

    Enter password: