`#!/usr/bin/python

-- coding: UTF-8 --

import MySQLdb

Open database connection

db = MySQLdb.connect("localhost", "testuser", "test123", "TESTDB", charset='utf8' )

Use cursor() Method get operation cursor

cursor = db.cursor()

Use execute Method execution SQL sentence

cursor.execute("SELECT VERSION()")

Use fetchone() Method to get a piece of data

data = cursor.fetchone()

print "Database version : %s " % data

Close database connection

db.close()`