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:
|
-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). OLTP access address: To obtain the VIP address and port number of peer nodes, log in to the console, navigate to the Instance Details page, locate the Basic Info section, and retrieve the peer node VIP from the Private Network Address field and the peer node Port from the Private Port field. |
-P
|
|
-u
| |
-p
| It is recommended to use interactive input to prevent password leakage. |
-c
| Preserve the comments in SQL statements. |