TDSQL for MySQL supports a connection method compatible with MySQL. It can be connected using the IP address, port number, username, and password, as shown below:
mysql -hxxx.xxx.xxx.xxx -Pxxxx -uxxx -pxxx -c
TDSQL for MySQL does not support clients earlier than version 4.0 and compression protocols. We recommend that you add the
-coption when using the client, so that you can use advanced features.
To connect to TDSQL for MySQL in PHP, you need to enable the MySQLi extension. A demo is as follows:
header("Content-Type:text/html;charset=utf-8"); $host="10.10.10.10"; //Instance proxy_host_ip $user="test"; //Instance user $pwd="test"; //Instance password $db="aaa"; //Database name $port="15002"; //proxy_host port number $sqltool=new MySQLli($host,$user,$pwd,$db,$port); //Other necessary code $sqltool->close(); echo "ok"."\n";
You can run the following code to connect to TDSQL for MySQL with JDBC:
private final String USERNAME = "test"; private final String PASSWORD = "123456"; private final String DRIVER = "com.mysql.jdbc.Driver"; private final String URL = "jdbc:mysql://10.10.10.10:3306?userunicode=true&characterEncoding=utf8mb4"; private Connection connection; private PreparedStatement pstmt; private ResultSet resultSet;
TDSQL for MySQL supports other connection methods compatible with MySQL, such as Navicat and ODBC.
Contact our sales team or business advisors to help your business.
Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.
Was this page helpful?