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

Connect to Instances

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-03-06 19:05:18

Connection Methods

The method to connect to TDSQL Boundless is as follows:
Private Network Connection (Recommended): Connect to the cloud database via the private network address. Use CVM to directly connect to the cloud database's private network address. This connection method uses the private network's high-speed network, resulting in low latency.
CVM and database must be under the same account and within the same VPC (in the same region).
The private network address is provided by default and can be viewed in the instance list of the TDSQL Boundless console.
Note:
For CVM and database under different VPCs (including the same account/different accounts, same region/different regions), the private network connection method see CCN.
Public Network Access: TDSQL Boundless by default only provides a private network (VPC) access address to ensure the security and high performance of data transmission. If you need to connect to the database from the public network (public network), it is recommended to use Tencent Cloud load balancing (CLB) as a transit bridge.

Preparations

Creating an Account

1. Log in to the TDSQL Boundless console, in the Instance List, click Instance ID or Operation in the Manage column to go to the instance management page.
2. On the instance management page, select the Account Management tab, and click Create Account.
3. In the pop-up dialog box, enter the account name, password, and remarks. After confirming that the information is correct, click OK.
4. Accounts created will have the following permissions:
SELECT,UPDATE,INSERT,ALTER,DELETE,CREATE,CREATE VIEW,SHOW DATABASES,INDEX,SHOW VIEW,PROCESS,DROP
After an account is created and the private network address is obtained, you can connect to TDSQL Boundless using third-party tools and program drivers.
For Windows, three methods are used as examples: connection via the command line, connection via the client, and connection via the JDBC driver.
For Linux, command-line connection is taken as an example.

Connecting from the Windows Side

Connecting via the Windows Command Line

1. Open the Windows command line and enter the following command in the correct path of MySQL.
mysql -hprivate_network_address -Pport number -uusername -p.
Enter password: ********** (enter the password).
2. After you enter the relevant code correctly, the following information is displayed, indicating successful connection to the database. Next, you can proceed with related operations in the database.
Welcome to the MySQL monitor. Commands end with ; or \\g.

Connecting via the Windows Client

1. Download a standard SQL client, such as MySQL Workbench or SQLyog. This document uses SQLyog as an example.
2. Open SQLyog, choose File > New Connection, enter the corresponding host address, port number, username, and password, and click Connect.
Host: Enter the private network address obtained earlier.
User Name: Enter the created account name.
Password: Enter the corresponding password of the account. If you forget your password, you can go to the console to modify it.
Port: Enter the port corresponding to the address.


3. Connection succeeded page is as shown in the following figure. On this page, you can perform related operations in the database.



JDBC Driver Connection for Windows

TDSQL Boundless supports programmatic driver connectivity. This document uses Java connecting via JDBC Driver for MySQL (Connector/J) as an example.
1. Download a JDBC jar package at MySQL's official website. Import it to the library referenced by Java.
2. Call JDBC codes as follows:
public static final String url = "private network address";
public static final String name = "com.mysql.jdbc.Driver"; //Call the JDBC driver.
public static final String user = "username".
public static final String password = "password".
//JDBC
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("url, user, password");
//
conn.close();
3. After the connection is successful, you can proceed with other operations in the database.

Connecting from the Linux Side

Command Line Connection for Linux

This document uses the CentOS 7.2 64-bit system in Tencent CVMs as an example. See Purchasing Method for purchasing CVMs.
1. Log in to Linux, enter the command yum install mysql, and use yum, the package management software that comes with CentOS, to download and install the MySQL client from the Tencent Cloud mirror source.



2. When the command line shows "complete", it indicates that the MySQL client installation is complete.
3. Enter the command mysql -h private network address -P port -u username -p to connect to the database, then you can proceed with sharding operations.
The following figure uses show databases; as an example.


Ajuda e Suporte

Esta página foi útil?

comentários