Data Management:Access a database instance over the MySQL protocol

// dpxxxx-xxxxxxxx.proxy.dms.aliyuncs.com:3306: the domain name and port number used to connect to the instance. You can view the domain name and port number in the proxy endpoint used to access the instance over the MySQL protocol on the Secure Access Proxy details page of the instance. 
// schema: the name of the database instance that you want to access. 
String url = "jdbc:mysql://dpxxxx-xxxxxxxx.proxy.dms.aliyuncs.com:3306/schema";
Properties properties = new Properties();
// AccessID: the AccessKey ID used to access the instance. You can view your AccessKey ID in the Authorization Information section on the Secure Access Proxy details page of the instance. 
properties.setProperty("user", "AccessID");
// AccessSecret: the AccessKey secret used to access the instance. You can view your AccessKey secret in the Authorization Information section on the Secure Access Proxy details page of the instance. 
properties.setProperty("password", "AccessSecret");
try (Connection connection = DriverManager.getConnection(url, properties)) {
    try (Statement statement = connection.createStatement()) {
        // Use the execute() method to execute an SQL statement. In this example, the SHOW DATABASES statement is executed. You can also execute other SQL statements. 
        statement.execute("SHOW DATABASES");
        ResultSet resultSet = statement.getResultSet();
        while (resultSet.next()) {
            System.out.println(resultSet.getString(1));
        }
    }
} catch (Exception e) {
    e.printStackTrace();
}

import pymysql

try:
    # host: the domain name of the instance. 
    # port: the port number used to connect to the instance. 
    # user: the AccessKey ID used to access the instance. You can view your AccessKey secret in the Authorization Information section on the Secure Access Proxy details page of the instance. 
    # password: the AccessKey secret used to access the instance. You can view your AccessKey secret in the Authorization Information section on the Secure Access Proxy details page of the instance. 
    # database: the name of the database instance that you want to access. 
    conn = pymysql.connect(host='dpxxxx-xxxxxxxx.proxy.dms.aliyuncs.com', port=3306, user='AccessID', password="AccessSecret",database ='schema')  
    cur = conn.cursor(pymysql.cursors.DictCursor)
    # Use the execute() method to execute an SQL statement. In this example, the SHOW DATABASES statement is executed. You can also execute other SQL statements. 
    cur.execute('SHOW DATABASES')
    rs = cur.fetchall()
    print rs
finally:
    cur.close()
    conn.close()

var mysql  = require('mysql');  
 
var connection = mysql.createConnection({
    // host: the domain name of the instance.  
    host     : 'dpxxxx-xxxxxxxx.proxy.dms.aliyuncs.com',  
    // user: the AccessKey ID used to access the instance. You can view your AccessKey secret in the Authorization Information section on the Secure Access Proxy details page of the instance.      
    user     : 'AccessID', 
    // password: the AccessKey secret used to access the instance. You can view your AccessKey secret in the Authorization Information section on the Secure Access Proxy details page of the instance.              
    password : 'AccessSecret', 
    // port: the port number used to connect to the instance.       
    port     : '3306',  
    // database: the name of the database instance that you want to access.                  
    database : 'schema' 
}); 
 
connection.connect();

// Use the execute() method to execute an SQL statement. In this example, the SHOW DATABASES statement is executed. You can also execute other SQL statements.  
connection.query('SHOW DATABASES', function(err, result) {
    console.log(result);
});
 
connection.end();