1、安装Python开发环境安装MySQL数据库安装Python连接MySQL的依赖包MySQLdb
2、编写代码文件python_connect_mysql.py
3、#! /usr/bin/env python#coding: utf8import MySQLdbif __name__ == "__main__": conn = None try: config = {"host":'127.0.0.1', "port":3306, "user":'test', "passwd":'12345678', "db":'test', "charset":'utf8'} conn = MySQLdb.connect(**config) conn.autocommit(True) cursor = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor) cursor.execute("select name,age from tbtest") rows = cursor.fetchall() for row in rows: print row["name"] print row["age"] except Exception, e: print str(e) finally: if conn: conn.close()
4、执行代码：pythonpython_connect_mysql.py
