blocks|key|4651127|text|如果您在编译二进制扩展时遇到问题，或者在无法编译的平台上遇到问题，可以尝试使用纯python+PyMySQL绑定。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4651128|只需简单地pip+install+pymysql并切换您的SQLAlchemy+URI，如下所示：|4651129|SQLALCHEMY_DATABASE_URI+=+'mysql%2Bpymysql://.....'|code-block|syntax|javascript|4651130|有一些other+drivers你也可以试试。|4651131|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/PyMySQL/PyMySQL|1|http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html#module-sqlalchemy.dialects.mysql.pymysql^0|1B|7|1B|7|0|0|5|J|0|0|3|D|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|18|8|@]|D|@$9|19|A|1A|1|1B]]|E|$]]|$1|O|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

If you're having issues compiling the binary extension, or on a platform where you cant, you can try using the pure python <a href="https://github.com/PyMySQL/PyMySQL"><code>PyMySQL</code></a> bindings.

Simply <code>pip install pymysql</code> and switch your SQLAlchemy URI to start like this:

<pre><code>SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://.....'
</code></pre>

There are some <a href="http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html#module-sqlalchemy.dialects.mysql.pymysql">other drivers</a> you could also try.

blocks|key|4651145|text|或者试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651146|apt-get+install+python-mysqldb|code-block|syntax|javascript|4651147|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Or try this: 

<pre><code>apt-get install python-mysqldb
</code></pre>

blocks|key|4651236|text|你可以试试吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651237|pip+install+mysqlclient|code-block|syntax|javascript|4651238|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

may you try

<pre><code>pip install mysqlclient
</code></pre>

blocks|key|144588|text|我的问题是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|144589|return+__import__('MySQLdb')
ImportError:+No+module+named+MySQLdb|code-block|syntax|javascript|144590|我的决心是：|144591|pip+install+MySQL-python
yum+install+mysql-devel.x86_64|144592|刚开始的时候，我只是安装了MySQL-python，但是这个问题仍然存在。所以我认为如果这个问题发生了，你也应该考虑mysql-devel。希望这能有所帮助。|144593|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

My issue is :

<pre><code>return __import__('MySQLdb')
ImportError: No module named MySQLdb
</code></pre>

and my resolution :

<pre><code>pip install MySQL-python
yum install mysql-devel.x86_64
</code></pre>

at the very beginning, i just installed MySQL-python, but the issue still existed. So i think if this issue happened, you should also take mysql-devel into consideration.
Hope this helps.

blocks|key|144551|text|我在开发SQLAlchemy时遇到了这个问题。SQLAlchemy对MySQL使用的默认方言是mysql%2Bmysqldb。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|144552|engine+=+create_engine('mysql%2Bmysqldb://scott:tiger@localhost/foo')|code-block|syntax|javascript|144553|当执行上面的命令时，我得到了"No+module+named+MySQLdb“错误。为了解决这个问题，我安装了mysql-python模块，这个问题已经解决了。|144554|sudo+pip+install+mysql-python|144555|entityMap^0|1B|D|0|0|F|N|1J|C|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|P|$]]

I got this issue when I was working on SQLAlchemy. The default dialect used by SQLAlchemy for MySQL is <code>mysql+mysqldb</code>.

<pre><code>engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')
</code></pre>

I got the "<code>No module named MySQLdb</code>" error when the above command was executed. To fix it I installed the <code>mysql-python</code> module and the issue was fixed.

<pre><code>sudo pip install mysql-python
</code></pre>

blocks|key|4651264|text|根据我的经验，这也取决于Python的版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651265|如果你使用的是Python+3，@DazWorrall+answer对我来说很好。|4651266|但是，如果您使用的是Python+2，则应|4651267|sudo+pip+install+mysql-python|code-block|syntax|javascript|4651268|这将在不改变SQLAlchemy+URI的情况下安装'MySQLdb‘模块。|4651269|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

It depends on Python Version as well in my experience.

If you are using Python 3, @DazWorrall answer worked fine for me.

However, if you are using Python 2, you should

<pre><code>sudo pip install mysql-python
</code></pre>

which would install 'MySQLdb' module without having to change the SQLAlchemy URI.

blocks|key|144737|text|所以我花了大约5个小时试图弄清楚在尝试运行时如何处理这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|144738|./manage.py+makemigrations|code-block|syntax|javascript|144739|对于Ubuntu+Server+LTS16.1，一个完整的LAMP堆栈，Apache2+MySql+5.7PHP7Python3和Django1.10.2，我真的很难找到一个好的答案。事实上，我仍然不满意，但唯一对我有效的解决方案是……|144740|sudo+apt-get+install+build-essential+python-dev+libapache2-mod-wsgi-py3+libmysqlclient-dev|144741|然后是(从虚拟环境内部)|144742|pip+install+mysqlclient|144743|当我尝试设置一个新的web服务器时，我真的不喜欢使用dev安装，但不幸的是，这种配置是我唯一可以选择的最舒适的方式。|144744|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

So I spent about 5 hours trying to figure out how to deal with this issue when trying to run

<pre><code>./manage.py makemigrations
</code></pre>

With Ubuntu Server LTS 16.1, a full LAMP stack, Apache2 MySql 5.7 PHP 7 Python 3 and Django 1.10.2 I really struggled to find a good answer to this. In fact, I am still not satisfied, but the ONLY solution that worked for me is this...

<pre><code>sudo apt-get install build-essential python-dev libapache2-mod-wsgi-py3 libmysqlclient-dev
</code></pre>

followed by (from inside the virtual environment)

<pre><code>pip install mysqlclient
</code></pre>

I really dislike having to use dev installs when I am trying to set up a new web server, but unfortunately this configuration was the only mostly comfortable path I could take.

blocks|key|4651354|text|虽然@Edward+van+Kuik的answer是正确的，但它没有考虑到issue+with+virtualenv+v1.7+and+above。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4651355|特别是，在Ubuntu上通过apt安装python-mysqldb会将其放在/usr/lib/pythonX.Y/dist-packages下，但默认情况下，此路径不包含在virtualenv的sys.path中。|style|CODE|4651356|因此，to+resolve+this，您应该通过运行以下命令来使用系统包创建virtualenv：|4651357|virtualenv+--system-site-packages+.venv|4651358|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/users/296637|1|https://stackoverflow.com/a/24364863|2|https://stackoverflow.com/q/19210964|3|https://stackoverflow.com/a/31658822^0|2|G|0|J|6|1|11|10|2|0|E|3|J|E|12|W|2P|8|0|3|F|3|0|0|13|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]|$A|13|B|14|1|15]|$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|6|7|19|8|@$A|1A|B|1B|F|G]|$A|1C|B|1D|F|G]|$A|1E|B|1F|F|G]|$A|1G|B|1H|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|1I|8|@]|9|@$A|1J|B|1K|1|1L]]|C|$]]|$1|J|3|K|5|6|7|1M|8|@$A|1N|B|1O|F|G]]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1P|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]|V|$5|O|P|Q|C|$R|W]]|X|$5|O|P|Q|C|$R|Y]]]]

While <a href="https://stackoverflow.com/users/296637">@Edward van Kuik</a>'s <a href="https://stackoverflow.com/a/24364863">answer</a> is correct, it doesn't take into account an <a href="https://stackoverflow.com/q/19210964">issue with virtualenv v1.7 and above</a>.

In particular installing <code>python-mysqldb</code> via <code>apt</code> on Ubuntu put it under <code>/usr/lib/pythonX.Y/dist-packages</code>, but this path isn't included by default in the virtualenv's <code>sys.path</code>.

So <a href="https://stackoverflow.com/a/31658822">to resolve this</a>, you should create your virtualenv with system packages by running something like:

<code>virtualenv --system-site-packages .venv</code>

blocks|key|4651433|text|在ubuntu+20中，你可以尝试这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651434|sudo+apt-get+install+libmysqlclient-dev
sudo+apt-get+install+gcc
pip+install+mysqlclient|code-block|syntax|javascript|4651435|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In ubuntu 20 , you can try this :

<pre><code>sudo apt-get install libmysqlclient-dev
sudo apt-get install gcc
pip install mysqlclient
</code></pre>

blocks|key|144819|text|yum+install+MySQL-python.x86_64|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|144820|对我很管用。|unstyled|144821|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre class="lang-sh prettyprint-override"><code>yum install MySQL-python.x86_64
</code></pre>

worked for me.

blocks|key|4651382|text|得到了这么多与权限相关的错误。你可以试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651383|xcode-select+--install|code-block|syntax|javascript|4651384|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Got so many errors related to permissions and what not. You may wanna try this : 

<pre><code>xcode-select --install
</code></pre>

blocks|key|144876|text|sudo+apt-get+install+python-mysqldb|type|unstyled|depth|inlineStyleRanges|entityRanges|data|144877|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

sudo apt-get install python-mysqldb

I am referring the following tutorial to make a login page for my web application.
<a href="http://code.tutsplus.com/tutorials/intro-to-flask-signing-in-and-out--net-29982" rel="noreferrer">http://code.tutsplus.com/tutorials/intro-to-flask-signing-in-and-out--net-29982</a>

I am having issue with the database.
I am getting an 

<pre><code>ImportError: No module named MySQLdb
</code></pre>

when I execute 

<pre><code>http://127.0.0.1:5000/testdb
</code></pre>

I have tried all possible ways to install python mysql, the one mentioned in the tutorial, easy_install, sudo apt-get install.

I have installed mysql in my virtual env. My directory structure is just the same as whats explained in the tutorial. The module is sucessfully installed in my system and still I am getting this error.

Please help. What could be causing this.

ImportError: No module named MySQLdb

我参考了下面的教程来为我的web应用程序创建一个登录页面。我的数据库有问题。我得到了一个ImportError: No module named MySQLdb当我执行的时候http://127.0.0.1:5000/testdb我已经尝试了所有可能的方法来安装python mysql，也就是教程easy_install，sudo apt-get install中提到的方法。我已经在我的虚拟环境中

问ImportError:没有名为MySQLdb的模块
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ImportError:没有名为MySQLdb的模块EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ImportError:没有名为MySQLdb的模块
EN