blocks|key|1071342|text|您将希望以这种方式将Python添加到Path环境变量中。请转至：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071343|我的电脑|ordered-list-item|1071344|系统特性|1071345|预置系统设置|1071346|在“高级”选项卡下单击“环境变量”按钮|1071347|然后在系统变量下添加/更改以下变量：PYTHONPATH和Path。下面是我的变量的粘贴：|offset|length|style|CODE|1071348|PYTHONPATH|BOLD|1071349|C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts|code-block|syntax|javascript|1071350|路径|1071351|C:\Program+Files\MySQL\MySQL+Utilities+1.3.5\;C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts|1071352|您的路径可能是不同的，所以请调整它们，但是这个配置适合我，您应该能够在进行这些更改后运行MySQL。|1071353|entityMap^0|0|0|0|0|0|I|A|T|4|0|0|A|0|0|0|2|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|18|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1A|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|1B|8|@$M|1C|N|1D|O|P]|$M|1E|N|1F|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1G|8|@$M|1H|N|1I|O|S]]|9|@]|A|$]]|$1|T|3|U|5|V|7|1J|8|@]|9|@]|A|$W|X]]|$1|Y|3|Z|5|6|7|1K|8|@$M|1L|N|1M|O|S]]|9|@]|A|$]]|$1|10|3|11|5|V|7|1N|8|@]|9|@]|A|$W|X]]|$1|12|3|13|5|6|7|1O|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|15|$]]

You're going to want to add Python to your Path Environment Variable in this way. Go to:

<ol>
<li>My Computer</li>
<li>System Properties</li>
<li>Advance System Settings</li>
<li>Under the "Advanced" tab click the button that says "Environment Variables"</li>
<li>Then under System Variables you are going to want to add / change the following variables: <code>PYTHONPATH</code> and <code>Path</code>. Here is a paste of what my variables look like:</li>
</ol>

PYTHONPATH

<pre><code>C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts
</code></pre>

Path

<pre><code>C:\Program Files\MySQL\MySQL Utilities 1.3.5\;C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts
</code></pre>

Your Path's might be different, so please adjust them, but this configuration works for me and you should be able to run MySQL after making these changes.

blocks|key|792994|text|尝试运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|792995|pip+install+mysqlclient|code-block|syntax|javascript|792996|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|$]]

try running the following command:

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

blocks|key|68928|text|如果您试图在mysqlclient上使用WINDOWS中的此故障，请尝试安装较低的版本：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|68929|pip+install+mysqlclient==1.3.4|code-block|syntax|javascript|68930|entityMap^0|6|B|K|7|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|S|8|@]|E|@]|F|$J|K]]|$1|L|3|-4|5|6|7|T|8|@]|E|@]|F|$]]]|M|$]]

If you are trying to use <code>mysqlclient</code> on WINDOWS with this failure, try to install the lower version instead:

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

blocks|key|68905|text|如果使用站点http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python，请下载该文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|68906|mysqlclient-1.3.6-cp34-无-win32.whl或|unordered-list-item|68907|mysqlclient-1.3.6-cp34-无-win_amd64.whl|68908|取决于您拥有的python版本(这些版本适用于python3.4)和您拥有的窗口类型(x64或x32)|68909|将此文件解压缩到C：\Python34+34\Lib\site-包中，您的项目就会工作。|68910|entityMap|0|LINK|mutability|MUTABLE|url|http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python^0|6|1J|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$]]|$1|G|3|H|5|F|7|Z|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|10|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|11|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

if you use the site <a href="http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python" rel="noreferrer">http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python</a> , download the file: 

<ul>
<li>mysqlclient‑1.3.6‑cp34‑none‑win32.whl or</li>
<li>mysqlclient‑1.3.6‑cp34‑none‑win_amd64.whl</li>
</ul>

depending on the version of python you have (these are for python 3.4) and the type of windows you have (x64 or x32)

extract this file into C:\Python34\Lib\site-packages and your project will work

blocks|key|1071382|text|MySQLdb有32位和64位的windows安装程序，支持从2.6到3.4。检查这里。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1071383|entityMap|0|LINK|mutability|MUTABLE|url|http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python^0|15|2|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There are windows installers for MySQLdb avaialable for both 32 and 64 bit, supporting Python from 2.6 to 3.4. Check <a href="http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python">here</a>.

blocks|key|68877|text|对于使用Python的人(现在应该是每个人)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|68878|不幸的是，MySQLPython1.2.5还不支持Python+(这有点不合理，Python1.2.5已经发布了一段时间了)。参考资料：https://pypi.python.org/pypi/MySQL-python/1.2.5|offset|length|68879|因此，我的解决办法是使用甲骨文的MySQL连接器。在settings.py中，将数据库的“ENGINE”字段更改为：“ENGINE”：“mysql.connector.django”，|68880|关于这个问题的第一个答案的最后一段可以找到更多的信息：将Django设置为使用MySQL。|68881|希望这能帮上忙！|68882|entityMap|0|LINK|mutability|MUTABLE|url|https://pypi.python.org/pypi/MySQL-python/1.2.5|1|https://stackoverflow.com/questions/19189813/setting-django-up-to-use-mysql^0|0|1W|1B|0|0|0|R|H|1|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]|T|$5|O|P|Q|A|$R|U]]]]

For folks using Python 3.0+ (which should be everyone now):

Unfortunately, MySQL-Python 1.2.5 does not support Python 3.0+ yet (which is kinda unreasonable IMHO, Python 3+ has been out for a while). Reference : <a href="https://pypi.python.org/pypi/MySQL-python/1.2.5" rel="nofollow noreferrer">https://pypi.python.org/pypi/MySQL-python/1.2.5</a>

So, my workaround is to use Oracle's MySQL connector. In settings.py, change DATABASE's 'ENGINE' field to:
'ENGINE': 'mysql.connector.django',

More info could be found in the last paragraph of the first answer to this question: <a href="https://stackoverflow.com/questions/19189813/setting-django-up-to-use-mysql">Setting Django up to use MySQL</a>

Hope this helps!!

blocks|key|792894|text|我有一个稍微不同的设置，但认为我的解决方案将帮助您。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|792895|我有一个Windows+8机器，Python2.7安装并通过eclipse运行我的东西。|792896|一些背景：|offset|length|style|BOLD|792897|当我做easy+install时，它会尝试安装MySQL-python+1.2.5，但error:+Unable+to+find+vcvarsall.bat失败了。我做了一个easy_install+of+pip，并尝试了pip安装，它也失败了，也有一个类似的错误。他们都引用了与visual有关的vcvarsall.bat，因为我的机器上没有visual，所以它让我寻找另一种解决方案，我在下面分享。|CODE|792898|解决方案：|792899|从https://www.python.org/download的2.7.8重新安装python2.7.8--这将添加任何缺少的注册表设置，这是下一次安装所必需的。|ordered-list-item|792900|从http://pypi.python.org/pypi/MySQL-python/1.2.4安装1.2.4|792901|在完成这两个安装之后，我能够通过eclipse查询我的MySQL+db。|792902|entityMap|0|LINK|mutability|MUTABLE|url|https://www.python.org/download|1|http://pypi.python.org/pypi/MySQL-python/1.2.4^0|0|0|0|5|0|3|C|N|I|17|Z|2F|C|2V|3|33|3|45|D|0|0|5|0|1|V|0|0|1|1A|1|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|16|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|17|8|@$F|18|G|19|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1A|8|@$F|1B|G|1C|H|L]|$F|1D|G|1E|H|L]|$F|1F|G|1G|H|L]|$F|1H|G|1I|H|L]|$F|1J|G|1K|H|L]|$F|1L|G|1M|H|L]|$F|1N|G|1O|H|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1P|8|@$F|1Q|G|1R|H|I]]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1S|8|@]|9|@$F|1T|G|1U|1|1V]]|A|$]]|$1|R|3|S|5|Q|7|1W|8|@]|9|@$F|1X|G|1Y|1|1Z]]|A|$]]|$1|T|3|U|5|6|7|20|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]|13|$5|Y|Z|10|A|$11|14]]]]

I have a slightly different setup, but think my solution will help you out.

I have a Windows 8 Machine, Python 2.7 installed and running my stuff through eclipse.

Some Background: 

When I did an <code>easy install</code> it tries to install <code>MySQL-python 1.2.5</code> which failed with an <code>error: Unable to find vcvarsall.bat</code>. I did an <code>easy_install</code> of <code>pip</code> and tried the <code>pip</code> install which also failed with a similar error. They both reference <code>vcvarsall.bat</code> which is something to do with visual studio, since I don't have visual studio on my machine, it left me looking for a different solution, which I share below.

The Solution:

<ol>
<li>Reinstall python 2.7.8 from 2.7.8 from <a href="https://www.python.org/download" rel="nofollow">https://www.python.org/download</a> this will add any missing registry settings, which is required by the next install.</li>
<li>Install 1.2.4 from <a href="http://pypi.python.org/pypi/MySQL-python/1.2.4" rel="nofollow">http://pypi.python.org/pypi/MySQL-python/1.2.4</a> </li>
</ol>

After I did both of those installs I was able to query my MySQL db through eclipse.

blocks|key|793101|text|MySqldb+python安装windows|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|793102|MySQLpython1.2.3用于Windows和Python2.7、32位和64位版本|793103|从这里下载python+mysql-python|793104|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codegood.com/archives/129^0|0|N|0|0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@]|D|@$9|W|A|X|1|Y]]|E|$]]|$1|J|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

MySqldb python install windows

MySQL-python 1.2.3 for Windows and Python 2.7, 32bit and 64bit versions

<a href="http://www.codegood.com/archives/129" rel="nofollow noreferrer">download python mysql-python from here</a>

blocks|key|793111|text|如果您在尝试pip+install+mysqlclient时遇到缺少MS+14构建工具的问题，可能的解决方案是https://stackoverflow.com/a/51811349/1552410。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|793112|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/51811349/1552410^0|6|N|1J|18|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

If you encounter the problem with missing MS VC 14 Build tools while trying <code>pip install mysqlclient</code> a possible solution for this may be <a href="https://stackoverflow.com/a/51811349/1552410">https://stackoverflow.com/a/51811349/1552410</a>

blocks|key|1071619|text|只需从这里下载mysqlclient，https://www.lfd.uci.edu/~gohlke/pythonlibs/在下载正确版本时要小心，这取决于您安装的python。然后继续进行导入。它对我有效，因为在我的例子中，错误告诉我安装Visual+C%2B%2B+14.0，这浪费了我的时间，在我的C驱动器中占用了大约10+of的空间。因此，建议使用pip安装mysqlclient安装mysqlclient。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1071620|entityMap|0|LINK|mutability|MUTABLE|url|https://www.lfd.uci.edu/~gohlke/pythonlibs/^0|J|17|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Just Download mysqlclient from here <a href="https://www.lfd.uci.edu/~gohlke/pythonlibs/" rel="nofollow noreferrer">https://www.lfd.uci.edu/~gohlke/pythonlibs/</a>
be careful while downloading the right version depending on your your python version installed.
Then proceed with the import. 
It worked for me because in my case the error was telling to install Visual Studio C++ 14.0 something which wasted my time and occupied around 10GB of space in my C drive.
So recommending installing mysqlclient using pip install mysqlclient

blocks|key|1071633|text|对于phpmydamin，可以使用以下步骤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071634|转到python安装路径，如
cd+C:\Users\Enamul\AppData\Local\Programs\Python\Python37-32\Scripts|ordered-list-item|1071635|运行命令pip+install+PyMySQL|offset|length|style|CODE|1071636|在python导入库中，如import+pymysql|1071637|与数据库的连接
db+=+pymysql.connect(host='localhost'，user='root'，passwd='yourpassword'，database="bd")|1071638|获取光标cursor+=+db.cursor()|1071639|创建表，如
Cursor.execute(“创建表客户(名称VARCHAR(255)，地址VARCHAR(255))")|1071640|entityMap^0|0|0|4|J|0|D|E|0|0|4|K|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|W|8|@$G|X|H|Y|I|J]]|9|@]|A|$]]|$1|K|3|L|5|D|7|Z|8|@$G|10|H|11|I|J]]|9|@]|A|$]]|$1|M|3|N|5|D|7|12|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|13|8|@$G|14|H|15|I|J]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|16|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|T|$]]

For phpmydamin you can use following step

<ol>
<li>Go to python install path like 

<pre><code> cd C:\Users\Enamul\AppData\Local\Programs\Python\Python37-32\Scripts
</code></pre></li>
<li>Run the command <code>pip install PyMySQL</code></li>
<li>In the python shell import library like <code>import pymysql</code></li>
<li>connection to databasbe 

<pre><code> db = pymysql.connect(host='localhost',user='root',passwd='yourpassword', database="bd")
</code></pre></li>
<li>get cursor <code>cursor = db.cursor()</code></li>
<li>Create table like

<pre><code>cursor.execute("CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))")
</code></pre></li>
</ol>

I've spent hours trying to make Django work on my computer. The problem is that I can't install the mysql-python package. I'm running Windows 7 64bit. This is what I've tried:

<ol>
<li>I have downloaded easy_install</li>
<li>I have downloaded Cygwin64 to be able to run Linux commands (Win cmd was driving me crazy)</li>
<li>I have typed in: easy_install mysql-python (gave me an error message saying it can't find vcvarsall.bat)</li>
<li>I have downloaded Visual Studio 2010. However, I uninstalled it since I found out that I had some other version of it already (it didn't solve the problem)</li>
</ol>

I have googled this problem like a thousand times, so I would be very grateful if someone could help me. Thanks in advance!

EDIT: I discovered this: <a href="https://pypi.python.org/pypi/MySQL-python/1.2.5" rel="noreferrer">https://pypi.python.org/pypi/MySQL-python/1.2.5</a>. Does this mean I can't run Django with python 3.3? And why bother to go through all this work if there is an .exe-file out there?

Install mysql-python (Windows)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我花了好几个小时试图让Django在我的电脑上工作。问题是我无法安装mysql-python包。我在运行Windows 7 64位。这就是我尝试过的：我下载了easy_install我下载了Cygwin64来运行Linux命令(Win cmd让我抓狂)我输入了: easy_install mysql-python (给了我一条错误消息，说它找不到vcvarsall.bat)我已经下载了Visual

问安装mysql (Windows)
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问安装mysql (Windows)EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问安装mysql (Windows)
EN