python 爬虫环境

urllib
re //正则表达式
requests
selenium //浏览器自动化测试工具
chromedriver.exe||phantomjs.exe //浏览器驱动
lxml beautifusoup4||pyquery //解析html
pymsql ||pymongo||redis
flask
django
jupyter //强大的记事本

安装以上所有

pip install requests selenium beautifulsoup4 pyquery pymysql pymongo redis flask django jupyter 

mysql 连接

conn = pymysql.connect(host="121.41.79.201",user="root",password="123456",port=3306,db="test")
cursor = conn.cursor()
cursor.execute("select *from account")
cursor.fetchone()