Using the MySQL Client to Connect to a Common Doris Cluster

Installing the Client

1. Prepare a Linux ECS. For details, see Preparing an ECS.
2. Install the client and connect to the cluster.
   1. Use the SSH login tool to remotely log in to the Linux ECS through the EIP.

      For details, see "Instance" > "Logging In to a Linux ECS" > "Logging In to an ECS Using an SSH Password" in the Elastic Cloud Server User Guide.

   2. Decompress the installation package.

      cd <Path of the client installation package>
      tar -xzvf Name of the client package
      
      

      Note

      Replace <Path of the client installation package> mentioned in 2.b with the actual path.

   3. Go to the bin directory.

      cd mysql-5.7.22-linux-glibc2.12-x86_64/bin/
      
      

   4. Connect to the Doris cluster.

      ./mysql -uadmin -pPassword -hInternal IP address of the cluster -P9030
      
      

      Note

      • Internal IP address of the cluster: Enter the cluster access address on the cluster details page. Replace it with the access address of the cluster you purchased. (All access addresses of the FE node can be used to access the cluster.)
      • Password is the password set when you purchase the cluster. If there are special characters, use backslashes (\) to escape them. If the password is enclosed in single quotation marks ('), the special characters do not need to be escaped.
      • Port: MySQL server port on the FE node. For details, see Table 1.

      Table 1 Custom security rules

      Direction	Action	Port/Range	Type	Destination/Source Address	Usage
      Outbound	Allow	All	IPv4/IPv6	0.0.0.0/0	Permit in the outbound direction
      Inbound	Allow	9030		Security group of the CloudTable Doris cluster	MySQL server port on the FE node
      	Allow	8030			HTTP server port on the FE node
      	Allow	8040			HTTP server port on the BE node
      	Allow	8050			HTTPS server port on the FE node