tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Configuration Change
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
DocumentationTDSQL BoundlessDeveloper GuideDeveloper Guide (MySQL Compatibility Mode)Connecting to the DatabaseConnect Using Command-line Client

Connect Using Command-line Client

PDF
Focus Mode
Font Size
Last updated: 2026-03-26 14:35:17
When you need to access the MySQL-compatible instance of the TDSQL Boundless database, you can connect using standard MySQL client tools. mysql is the command-line client officially provided by MySQL, which needs to be installed separately. TDSQL Boundless, as a new-generation distributed database, provides multi-engine compatibility, among which the MySQL-compatible instance highly supports MySQL protocols and syntax.

Prerequisites

The computer where the client resides has compatible MySQL client software installed. TDSQL Boundless recommends using the 8.0 version client.
The system environment variable PATH contains the installation path of the MySQL client.
Ensure the connectivity from the computer where the client resides to TDSQL Boundless.

Connection Steps

Open the corresponding terminal or command prompt window based on your operating system (Windows/Linux/macOS).
mysql -htdsql_host -P3306 -utdsql_username -pdummypassword -c
Connection Parameters:
Parameter
Description
-h
Specify the virtual IP address and service port of TDSQL Boundless (the default port is 3306, which is the same as MySQL's standard configuration).
The access address for OLTP: To obtain the peer node VIP address and port number, log in to the console. On the Instance Details page, locate the Basic Info section. The Private Network Address field provides the peer node VIP, while the Private Port field provides the peer node port.
The access address for OLAP: To view the VIP address and port number of the columnar node, log in to the console. On the Instance Details page, navigate to the Instance Architecture Diagram section. Under Columnar Node, you can find the corresponding VIP and Port information.
-P
-u
The database username created in TDSQL Boundless. For details, see Creating an Account.
-p
It is recommended to use interactive input to prevent password leakage.
-c
Preserve the comments in SQL statements.
Previous Topic: TDSQL Boundless Selection Guide and Practical TutorialNext Topic: Connect using a database connection pool

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback