This topic describes how to use the Python MySQLdb module to connect to an AnalyticDB for MySQL cluster.
#! /usr/bin/python # -*- coding: UTF-8 -*- import MySQLdb # Enable the database connection. # host: the endpoint or IP address of the AnalyticDB for MySQL cluster to which you want to connect. # port: the port number of the AnalyticDB for MySQL cluster endpoint. # user: the account used to connect to the AnalyticDB for MySQL cluster. There are two types of accounts: privileged and standard. # passwd: the password of the account used to connect to the AnalyticDB for MySQL cluster. # db: the name of the database in the AnalyticDB for MySQL cluster. db = MySQLdb.connect(host='am-bp***.ads.aliyuncs.com', port=3306, user='account_name', passwd='account_password', db='db_name') # Use the cursor() method to obtain an operation cursor. cursor = db.cursor() # Use the execute() method to execute SQL statements. cursor.execute("SELECT VERSION()") # Use the fetchone() method to obtain a data entry. data = cursor.fetchone() print "Database version : %s " % data # Disable the database connection. db.close()