连接方法1

 #_*_coding:gb2312 _*_ 
import os
import sys
import MySQLdb

def getdata():
    print("getdate")
    try:
      print("run")  
      conn = MySQLdb.connect(host='192.168.1.99', user='root', passwd='k123!', db='test', port=3306, charset='utf8')
      try:
            #cur = conn.cursor()
            #sql = "insert into tbl(id,name,pass) values(1,'中文','kling')"
            #conn.exceute(sql)
            print("运行成功")
            #cur.execute(sql)
            #allPerson = cur.fetchall()
      finally:
            #cur.close()
            conn.close()

    except Exception,e :
        print("数据库错误",e)
        return

if __name__=='__main__':
    getdata()    
    print(raw_input())

连接方法2

#coding:utf-8
'''
使用utf-8编码
使用adodbapi连接mysql数据库 
Created on 2012-9-13
@author: lren
'''
import sys
import MySQLdb

class conmysql:
    '''
            连接mysql数据库
    '''
    def __init__(self):
        self.connstr="Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.90;Port=3306;Database=xbookv1;user id=root;password=l123!;"
        #显示
        self.conn=MySQLdb.connect(host='192.168.1.90', user='root', passwd='l123!', db='xbookv1', port=3306, charset='utf8')

    def connected(self):
        return True


    def query(self):
        cur=self.conn.cursor()
        sql="select * from book limit 10"
        cur.execute(sql)
        print((u"查询到共%s结果")%cur.rowcount)
        #显示列名
        #for d in cur.description:
        #    print("%d,%s",d[0],d[1])

        #返回结果集
        rets=cur.fetchall()
        for rec in rets:
            print(("%s,%s")%(rec[0],rec[1])) 

        #print 'repr() of next row is...'
        #print(repr(cur.next()))

if __name__ == '__main__':    
    #print(u"系统版本:"+sys.version)
    #print(u"中文中国")

    con=conmysql()
    print(con.connstr)
    con.query()
    input("input char exit")