在Win10下通过pip安装python的mysql扩展包MySQLdb时，报错如下：
running build_ext
building '_mysql' extension
error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27
building '_mysql' extension
error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27
----------------------------------------
Failed building wheel for MySQL-python
Running setup.py clean for MySQL-python
Failed to build MySQL-python
Failed building wheel for MySQL-python
Running setup.py clean for MySQL-python
Failed to build MySQL-python
看提示语并对照自己的系统，的确没有安装Microsoft Visual c++ 9,这是pip安装该数据库扩展包所必须的编译工具。偷个懒，直接安装其exe文件，在Python官网就有下载：
安装程序运行完毕就可以在python文件中输入以下代码进行测试：
# coding=utf8
import pandas as pd
import MySQLdb as db
db_cn= db.connect(host='localhost', port=3306,user='root', passwd='', db='zzkook' ,charset = 'utf8')
df = pd.read_sql('select * from node;', con=db_cn)
著作权归作者所有。商业转载请联系本站作者获得授权，非商业转载请注明出处 ZZKOOK。
评论
谢谢哈
纳入收藏夹。
ZZKOOK，昊天罔极。
跪求初级内容
谢了呦