python3 mysql

1.下载mysql 

mysql社区版 https://www.mysql.com/downloads/ 或 链接：http://pan.baidu.com/s/1nvh2fTv密码：4xoo

2.下载navicat for mysql  

链接： http://pan.baidu.com/s/1jICapk6  密码：z5tp

3.安装教程 

http://www.cnblogs.com/wongbingming/p/6829481.html  ps：牢记密码

4.pymysql下载

https://pypi.python.org/pypi/PyMySQL

放到python/Scripts目录下

4.pymysql安装

运行cmd，进入python目录下Scripts的pymysql目录

运行 python setup.py install

5.实例

import pymysqlconn = pymysql.connect("localhost","root","123456","trux" ) #用户名root 密码123456 数据库名truxcursor = conn.cursor()query = ('select name, age from test')#读取表test 里name和age列cursor.execute(query)for (name, age) in cursor:    print(name, age)cursor.close()conn.close()