如何为蟒蛇安装MySQLdb？

Question

我从here尝试了conda install -c anaconda mysql-connector-python，但在安装之后我尝试运行import MySQLdb as db buy it to error：

---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-5-08dd46cbf704> in <module>
      1 ## package used to connect the database
----> 2 import MySQLdb as db
      3 import pandas as pd
      4 import numpy as np
      5 import warnings

ModuleNotFoundError: No module named 'MySQLdb'

如何为蟒蛇安装MySQLdb？

Answer 1

对于MySQLdb，您必须安装Python2的mysql-python：

conda install -c anaconda mysql-python

对于Python2和Python3，mysqlclient是推荐使用的库：

conda install -c anaconda mysqlclient

以下是Django对mysql库https://docs.djangoproject.com/en/3.0/ref/databases/#mysql-db-api-drivers的推荐

Answer 2

根据mysqldb's pypi page，您需要将mysqldb安装为

pip install MySQL-python

总而言之:您安装了错误的python库，正确的方法是：

conda install -c anaconda mysql-python