blocks|key|780741|text|为mysql安装dev+bits摆脱了我遇到的config-win.h错误，并抛出了另一个错误。Failed+to+load+and+parse+the+manifest.+The+system+cannot+find+the+file+specified.我在这篇文章中找到了我的问题的答案：http://www.fuyun.org/2009/12/install-mysql-for-python-on-windows/。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|780742|我将文件'C:\Python26\Lib\distutils\msvc9compiler.py`‘复制到我的virtualenv中，进行了上面链接中建议的编辑，一切正常。|780743|entityMap|0|LINK|mutability|MUTABLE|url|http://www.fuyun.org/2009/12/install-mysql-for-python-on-windows/^0|N|C|1C|29|43|1T|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

Installing dev bits for mysql got rid of the <code>config-win.h</code> error I was having, and threw another. <code>Failed to load and parse the manifest. The system cannot find the file specified.</code> I found the answer to my problem in this post: <a href="http://www.fuyun.org/2009/12/install-mysql-for-python-on-windows/" rel="nofollow noreferrer">http://www.fuyun.org/2009/12/install-mysql-for-python-on-windows/</a>.

I copied the file 'C:\Python26\Lib\distutils\msvc9compiler.py` into my virtualenv, made the edit suggested in the above link, and things are working fine.

blocks|key|2189316|text|答案很可能是安装MySQL+Developer+Build，并在配置过程中选择"C+headers\libs“选项。(如本文所述:为rationalpie.wordpress.com上的Windows上的Python构建MySQLdb+)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189317|也许更好的解决方案是安装一个预编译的版本：http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe|offset|length|2189318|entityMap|0|LINK|mutability|MUTABLE|url|http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe^0|0|L|1X|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Most probably the answer is to install MySQL Developer Build and selecting "C headers\libs" option during configuration. (as reported in this entry: Building MySQLdb for Python on Windows on rationalpie.wordpress.com)

Maybe even better solution is to install a precompiled build: <a href="http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe" rel="noreferrer">http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe</a>

blocks|key|1959079|text|试试ActivePython，|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1959080|pypm+-E+C:\myvirtualenv+install+mysql-python|code-block|syntax|javascript|1959081|entityMap|0|LINK|mutability|MUTABLE|url|http://code.activestate.com/pypm/mysql-python/^0|2|C|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Try <a href="http://code.activestate.com/pypm/mysql-python/" rel="nofollow">ActivePython</a>,

<pre><code>pypm -E C:\myvirtualenv install mysql-python
</code></pre>

blocks|key|2189381|text|mysql+5.5和config-win.h更新不可见问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189382|在5.5+config-win中。实际上已经移动到windows中的Connector+separate文件夹。例如smth，如：|2189383|C:\Program+Files\MySQL\Connector+C+6.0.2\include|2189384|要解决这个问题，不仅需要下载"dev+bits“(实际连接连接器)，还需要修改mysqldb安装脚本以添加include文件夹。我已经做了一个像那样的快速修复。|2189385|site.cfg：|2189386|#+Windows+connector+libs+for+MySQL.
connector+=+C:\Program+Files\MySQL\Connector+C+6.0.2|code-block|syntax|javascript|2189387|在setup_windows.py中找到该行|2189388|include_dirs+=+[+os.path.join(mysql_root,+r'include')+]:|2189389|并添加：|2189390|include_dirs+=+[+os.path.join(options['connector'],+r'include')+]|2189391|在那之后。|2189392|虽然很难看，但在mysqldb作者改变行为之前是有效的。|2189393|2189394|几乎忘了提一下。以同样的方式，我们需要为libs添加类似的附加条目：|2189395|library_dirs+=+[+os.path.join(options['connector'],+r'lib\opt')+]|2189396|也就是说，你的setup_windows.py看起来很像：|2189397|...
library_dirs+=+[+os.path.join(mysql_root,+r'lib\opt')+]
library_dirs+=+[+os.path.join(options['connector'],+r'lib\opt')+]
libraries+=+[+'kernel32',+'advapi32',+'wsock32',+client+]
include_dirs+=+[+os.path.join(mysql_root,+r'include')+]
include_dirs+=+[+os.path.join(options['connector'],+r'include')+]
extra_compile_args+=+[+'/Zl'+]
...|2189398|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1D|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1E|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1F|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1G|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|1I|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|1J|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|1K|8|@]|9|@]|A|$M|N]]|$1|W|3|X|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1M|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1O|8|@]|9|@]|A|$]]|$1|13|3|14|5|L|7|1P|8|@]|9|@]|A|$M|N]]|$1|15|3|16|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|17|3|18|5|L|7|1R|8|@]|9|@]|A|$M|N]]|$1|19|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|1A|$]]

Update for mysql 5.5 and config-win.h not visible issue

In 5.5 config-win. has actually moved to Connector separate folder in windows. i.e. smth like:

C:\Program Files\MySQL\Connector C 6.0.2\include

To overcome the problem one need not only to download "dev bits" (which actually connects the connector) but also to modify mysqldb install scripts to add the include folder. I've done a quick dirty fix as that. 

site.cfg:

<pre><code># Windows connector libs for MySQL.
connector = C:\Program Files\MySQL\Connector C 6.0.2
</code></pre>

in setup_windows.py locate the line 

<pre><code>include_dirs = [ os.path.join(mysql_root, r'include') ]:
</code></pre>

and add:

<pre><code>include_dirs = [ os.path.join(options['connector'], r'include') ]
</code></pre>

after it.

Ugly but works until mysqldb authors will change the behaviour.

<hr>

Almost forgot to mention. In the same manner one needs to add similar additional entry for libs:

<pre><code>library_dirs = [ os.path.join(options['connector'], r'lib\opt') ]
</code></pre>

i.e. your setup_windows.py looks pretty much like:

<pre><code>...
library_dirs = [ os.path.join(mysql_root, r'lib\opt') ]
library_dirs = [ os.path.join(options['connector'], r'lib\opt') ]
libraries = [ 'kernel32', 'advapi32', 'wsock32', client ]
include_dirs = [ os.path.join(mysql_root, r'include') ]
include_dirs = [ os.path.join(options['connector'], r'include') ]
extra_compile_args = [ '/Zl' ]
...
</code></pre>

blocks|key|780898|text|如果你仍然有这个问题，你可以从http://code.google.com/p/soemin/downloads/detail?name=MySQL-python-1.2.3.win32-py2.7.exe下载安装程序|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|780899|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/soemin/downloads/detail?name=MySQL-python-1.2.3.win32-py2.7.exe^0|F|2G|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]]]]

Well, if you are still having the problem, you can download the installer from <a href="http://code.google.com/p/soemin/downloads/detail?name=MySQL-python-1.2.3.win32-py2.7.exe" rel="nofollow">http://code.google.com/p/soemin/downloads/detail?name=MySQL-python-1.2.3.win32-py2.7.exe</a>

blocks|key|1959135|text|我对MySQLdb也很头疼。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1959136|为什么不使用官方的MysQL+Python+Connector呢？|1959137|easy_install+mysql-connector-python|code-block|syntax|javascript|1959138|或者你可以从这里下载：http://dev.mysql.com/downloads/connector/python/|offset|length|1959139|文档：http://dev.mysql.com/doc/refman/5.5/en/connector-python.html|1959140|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/python/|1|http://dev.mysql.com/doc/refman/5.5/en/connector-python.html^0|0|0|0|B|1C|0|0|3|1O|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@$K|12|L|13|1|14]]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@$K|16|L|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

I had a lot of headache with MySQLdb too.

Why not use the official MysQL Python Connector?

<pre><code>easy_install mysql-connector-python
</code></pre>

Or you can download it from here:
<a href="http://dev.mysql.com/downloads/connector/python/" rel="nofollow">http://dev.mysql.com/downloads/connector/python/</a>

Documentation:
<a href="http://dev.mysql.com/doc/refman/5.5/en/connector-python.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/connector-python.html</a>

blocks|key|2189471|text|我所要做的就是去甲骨文，下载MySQL连接器C+6.0.2+(更新的版本不能工作！)并执行典型的安装。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189472|https://downloads.mysql.com/archives/c-c/|offset|length|2189473|请确保通过自定义安装包含所有可选的额外文件(额外的二进制文件)，如果没有这些文件，它将不适用于win64.msi|2189474|完成后，我进入pycharms，选择MySQL-python>=1.2.4包进行安装，它工作得很好。不需要更新任何配置或类似的东西。对我来说，这是最简单的版本。|2189475|希望能有所帮助|2189476|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|15|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Z|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]]]

All I had to do was go over to oracle, and download the MySQL Connector C 6.0.2 (newer doesn't work!) and do the typical install.

<a href="https://downloads.mysql.com/archives/c-c/" rel="noreferrer">https://downloads.mysql.com/archives/c-c/</a>

Be sure to include all optional extras (Extra Binaries) via the custom install, without these it did not work for the win64.msi

Once that was done, I went into pycharms, and selected the MySQL-python>=1.2.4 package to install, and it worked great. No need to update any configuration or anything like that. This was the simplest version for me to work through.

Hope it helps

blocks|key|781013|text|被接受的解决方案似乎不再适用于较新版本的mysql-python。安装程序不再提供要编辑的site.cfg文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|781014|如果您正在安装mysql-python，它将查找C:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2\include。如果您有64位的MySQL安装，您可以简单地调用：|781015|781016|mklink+/d+"C:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2\include"+"C:\Program+Files\MySQL\MySQL+Connector+C+6.0.2\include"|ordered-list-item|781017|Run+pip+install+mysql-python|781018|Delete在步骤1中创建的符号链接|781019|781020|entityMap^0|19|8|0|O|1O|0|0|0|3L|0|4|O|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|L|3|M|5|K|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|N|3|O|5|K|7|15|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|16|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|R|$]]

The accepted solution no longer seems to work for newer versions of mysql-python. The installer no longer provides a <code>site.cfg</code> file to edit.

If you are installing mysql-python it'll look for <code>C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include</code>. If you have a 64-bit installation of MySQL, you can simply invoke:

<ol>
<li><code>mklink /d "C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "C:\Program Files\MySQL\MySQL Connector C 6.0.2\include"</code></li>
<li>Run <code>pip install mysql-python</code></li>
<li>Delete the symbolic link created in step 1</li>
</ol>

blocks|key|781058|text|接受的答案已过期。其中一些建议已经包含在包中，而我仍然收到关于缺少config-win.h+&+mysqlclient.lib的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|781059|781060|Install+mysql-connector-c-6.0.2-win32.msi|unordered-list-item|offset|length|781061|781062|conenctor也有一个压缩文件，但这不起作用，因为mysqlclient.lib在lib目录中，而安装程序希望它在lib/opt中。而不是黑客攻击site.cfg或setup_windows.py，微系统完成了这项工作。|style|CODE|781063|安装mysql-python的|781064|pip|781065|781066|另外，由于我不再使用MySQL，我的答案可能也过时了。|781067|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/c/6.0.html#downloads^0|0|0|8|X|0|0|0|R|F|17|3|1N|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@]|9|@$F|14|G|15|1|16]]|A|$]]|$1|H|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|18|8|@$F|19|G|1A|K|L]|$F|1B|G|1C|K|L]|$F|1D|G|1E|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|P|5|E|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1I|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10]]]]

The accepted answer is out of date. Some of the suggestions were already incorporated in the package, and I was still getting the error about missing config-win.h &amp; mysqlclient.lib.

<ul>
<li>Install <a href="http://dev.mysql.com/downloads/connector/c/6.0.html#downloads" rel="nofollow noreferrer">mysql-connector-c-6.0.2-win32.msi</a> 

<blockquote>
 There's a zip file for the conenctor too but that didn't work because
 <code>mysqlclient.lib</code> is in <code>lib</code> directory whereas the installer expects
 it in <code>lib/opt</code>. Instead of hacking site.cfg or setup_windows.py, the
 msi does the job.
</blockquote></li>
<li>pip install mysql-python</li>
</ul>

P.S. Since I don't use MySQL anymore, my answer may be out of date as well.

blocks|key|2189654|text|如果pip无法安装"MySQLdb"，一种解决办法是首先从此链接下载并安装到您的计算机上。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189655|http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python|offset|length|2189656|然后将所有MySQL*和_mysql*文件和目录从system+Python复制到Virtualenv目录：|2189657|c:\Python27\Lib\site-packages+(或类似的系统Python路径)到c:\my_virtenv\Lib\site-packages+(virtualenv的路径)|style|CODE|2189658|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1J|0|0|0|0|T|1B|V|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@$D|Z|E|10|J|K]|$D|11|E|12|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]]]

If pip fails to install "MySQLdb", a workaround is to download and install it on your machine first from this link

<a href="http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python" rel="noreferrer">http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python</a>

then copy all MySQL* and _mysql* files and directories from your system Python to your Virtualenv dir:

<code>c:\Python27\Lib\site-packages</code> (or similar path to your system Python) to
<code>c:\my_virtenv\Lib\site-packages</code> (path to your virtualenv)

blocks|key|656516|text|在我的例子中，我的修复方法是复制从mysql-+Connector+-c-+6.0.2+-win32.msi+(在上一篇文章中从用户名缓冲区中引用)创建的文件夹，该文件夹位于c:\Program+Files\MySQL\MySQL+Connector+C+6.0.2，并使用Program+Files+(x86)创建一个新路径并将内容粘贴到那里，因为安装不能正确地在32位和64位机器之间进行检查。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|656517|因此，新路径是C:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2。这是安装程序要查找的路径，所以我将文件粘贴到这里以帮助安装程序查找文件，这导致了关于缺少config-win.h的错误|656518|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In my case, my fix was copying the folder created from mysql-connector-c-6.0.2-win32.msi (referenced from username buffer in a previous post), which is located at c:\Program Files\MySQL\MySQL Connector C 6.0.2 and creating a new path with Program Files (x86) and pasting the content there since the installation is not properly checking between 32-bit and 64-bit machines. 

So, the new path is C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2. This is the path that the installer is looking to find, so I pasted the files there to help the installer to find the files, which was causing the error about missing config-win.h

blocks|key|2189766|text|我遵循了Bugagotti的回答，它不能在我的mysql-python-1.2.5的windows+(Win7+64位，py27和安装了mysql连接器6.1+)中工作，所以我在mysql-python-1.2.5中做了一些甚至很脏的更改：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189767|首先，site.cfg：|2189768|connector+=+C:\Program+Files\MySQL\MySQL+Connector+C+6.1|code-block|syntax|javascript|2189769|第二，_mysql.c：|2189770|#if+defined(MS_WINDOWS)
#include+<config-win.h>
#else
#include+"my_config.h"
#endif|2189771|至：|2189772|#if+0+/*defined(MS_WINDOWS)*/
#include+<config-win.h>
#else
#include+"my_config.h"
#endif|2189773|通过这些更改，config_win.h问题将会消失，但仍然存在链接问题：|2189774|LINK+:+fatal+error+LNK1181:+cannot+open+input+file+'mysqlclient.lib'|2189775|为此，我更改了setup_windows.py：|2189776|library_dirs+=+[+os.path.join(connector,+r'lib\vs9')+]++##+the+original+value+was+r'lib\opt'|2189777|然后它终于起作用了。|2189778|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1B|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|Y|3|Z|5|6|7|1D|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|11|$]]

I did follow the answer from Bugagotti, And it does not work in my windows (Win7 64 bit, py27 and have mysql connector 6.1 installed) for mysql-python-1.2.5, so I made some even dirty changes inside mysql-python-1.2.5:

First, the site.cfg:

<pre><code>connector = C:\Program Files\MySQL\MySQL Connector C 6.1
</code></pre>

Second, the _mysql.c :

<pre><code>#if defined(MS_WINDOWS)
#include &lt;config-win.h&gt;
#else
#include "my_config.h"
#endif
</code></pre>

To:

<pre><code>#if 0 /*defined(MS_WINDOWS)*/
#include &lt;config-win.h&gt;
#else
#include "my_config.h"
#endif
</code></pre>

And with these changes ,the config_win.h issue will gone, but there is still a link issue:

<pre><code>LINK : fatal error LNK1181: cannot open input file 'mysqlclient.lib'
</code></pre>

For this, I changed the setup_windows.py:

<pre><code>library_dirs = [ os.path.join(connector, r'lib\vs9') ] ## the original value was r'lib\opt'
</code></pre>

Then it worked finally.

blocks|key|2189806|text|我遵循了沈明才的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2189807|但在我的示例中，我将连接器更改为|2189808|connector+=+C:\Program+Files\MySQL\MySQL+Connector.C+6.1|code-block|syntax|javascript|2189809|并将library_dirs更改为|2189810|library_dirs+=+[+os.path.join(connector,+r'lib\vs10')+]|2189811|因为我没有vs9目录。它起作用了，但是我不知道为什么。|offset|length|style|CODE|2189812|我安装了vs2012，而连接器的lib目录只有vs10和vs11，其中vs11不起作用。我安装的VCForPyhton27.mis似乎支持vs9。|2189813|不管怎么说，这是可行的。如果你想冒险，你可以试一试。|2189814|entityMap^0|0|0|0|0|0|5|3|0|N|4|S|4|Z|4|1X|3|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|13|8|@$O|14|P|15|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@$O|17|P|18|Q|R]|$O|19|P|1A|Q|R]|$O|1B|P|1C|Q|R]|$O|1D|P|1E|Q|R]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1F|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$]]

I followed Mingcai SHEN's method.

But in my case, I changed the connector to

<pre><code>connector = C:\Program Files\MySQL\MySQL Connector.C 6.1
</code></pre>

And the library_dirs is changed to 

<pre><code>library_dirs = [ os.path.join(connector, r'lib\vs10') ]
</code></pre>

because I don't have a <code>vs9</code> directory. It works, but I don't know why.

I have vs2012 installed, and the lib directory of the connector only has <code>vs10</code> and <code>vs11</code>, in which <code>vs11</code> doesn't work. The VCForPyhton27.mis I installed seems to support <code>vs9</code>.

Anyway, this works. And if you want to risk it, you can try.

blocks|key|781364|text|我知道这篇文章太老了，但它仍然是谷歌最热门的文章，所以我将在这期文章中添加更多的信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|781365|我遇到了与OP相同的问题，但似乎没有一个建议的答案对我有效。主要是因为"config-win.h“不存在于连接器安装文件夹中的任何位置。|781366|我使用的是最新的连接器C+6.1.6，因为这是MySQL安装程序建议的版本。|781367|然而，最新的MySQL-python包(1.2.5)似乎不支持这一点。在尝试安装它时，我可以看到它显式地在寻找C连接器6.0.2。|781368|"-IC:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2\include"|code-block|syntax|javascript|781369|因此，通过从https://dev.mysql.com/downloads/file/?id=378015安装此版本，python包的安装没有任何问题。|offset|length|781370|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/file/?id=378015^0|0|0|0|0|0|6|1B|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

I know this post is super old, but it is still coming up as the top hit in google so I will add some more info to this issue. 

I was having the same problems as OP but none of the suggested answers seemed to work for me. Mainly because "config-win.h" didn't exist anywhere in the connector install folder. 

I was using the latest Connector C 6.1.6 as that was what was suggested by the MySQL installer. 

This however doesn't seem to be supported by the latest MySQL-python package (1.2.5). When trying to install it I could see that it was explicitly looking for C Connector 6.0.2. 

<pre><code>"-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include"
</code></pre>

So by installing this version from <a href="https://dev.mysql.com/downloads/file/?id=378015" rel="noreferrer">https://dev.mysql.com/downloads/file/?id=378015</a> the python package installed without any problem.

blocks|key|1959335|text|我在Windows上使用的解决方案是:同时安装32-bit和64-bit两个版本的MySQL+Connector/C+6.0.2。打开Command+Prompt并运行：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1959336|pip+install+mysql-python|code-block|syntax|javascript|1959337|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/c/6.0.html#downloads^0|2|7|N|2|U|2|1V|E|15|N|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

Solution that worked for me on <code>Windows</code>: Install both the <code>32</code>-bit and <code>64</code>-bit versions of the <a href="http://dev.mysql.com/downloads/connector/c/6.0.html#downloads" rel="nofollow">MySQL Connector/C 6.0.2</a>. Open <code>Command Prompt</code> and run:

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

blocks|key|2189947|text|如果您使用Visual+Studio或其他方式在虚拟环境中执行此操作，请尝试easy_install+MySQL-python|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2189948|entityMap^0|12|P|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

If you are doing this in a virtual environment whether using Visual Studio or otherwise, try 
<code>easy_install MySQL-python</code>

blocks|key|1959363|text|对我来说，以下方法解决了这个问题(Python+3.5.2；mysqlclient+1.3.9)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1959364|1959365|下载最新的MySQL+C连接器http://dev.mysql.com/downloads/connector/c/+(对我来说是Windows+(x86，64位)，MSI+c:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.1\|ordered-list-item|offset|length|style|CODE|1959366|Run+pip+install+mysqlclient|1959367|optional+http://dev.mysql.com/downloads/connector/c/+to+c:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.1\|1959368|Runpip+install+mysqlclient|1959369|optional+delete+c:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.1\|1959370|+)|1959371|由于构建脚本试图在x86程序文件目录中定位C连接器包含，因此此处的问题仅适用于x64位安装所有者。|1959372|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/c/|1^0|0|0|2F|1F|F|17|0|0|4|N|0|1K|1F|9|17|1|0|3|N|0|G|1F|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@$F|17|G|18|H|I]]|9|@$F|19|G|1A|1|1B]]|A|$]]|$1|J|3|K|5|E|7|1C|8|@$F|1D|G|1E|H|I]]|9|@]|A|$]]|$1|L|3|M|5|E|7|1F|8|@$F|1G|G|1H|H|I]]|9|@$F|1I|G|1J|1|1K]]|A|$]]|$1|N|3|O|5|E|7|1L|8|@$F|1M|G|1N|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1O|8|@$F|1P|G|1Q|H|I]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1R|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1S|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]|13|$5|Y|Z|10|A|$11|12]]]]

For me the following approach solved the issue (Python 3.5.2; mysqlclient 1.3.9):

<ol>
<li>Dowload latest MySQL C Connector <a href="http://dev.mysql.com/downloads/connector/c/" rel="nofollow noreferrer">http://dev.mysql.com/downloads/connector/c/</a> (for me was Windows (x86, 64-bit), MSI Installer)</li>
<li>Copy <code>c:\Program Files\MySQL\MySQL Connector C 6.0.2\</code> directory to <code>c:\Program Files (x86)\MySQL\MySQL Connector C 6.1\</code></li>
<li>Run <code>pip install mysqlclient</code></li>
<li>[optional] delete <code>c:\Program Files (x86)\MySQL\MySQL Connector C 6.1\</code></li>
</ol>

The issue here is only for x64 bit installation owners, since build script is trying to locate C connector includes in x86 program files directory.

blocks|key|1959377|text|从此|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1959378|下载|ordered-list-item|1959379|1959380|-+Python+2.7:+[https://pypi.python.org/pypi/mysqlclient/1.3.9](https://pypi.python.org/pypi/mysqlclient/1.3.6)
-+Python+3.6:+[https://pypi.python.org/pypi/mysqlclient](https://pypi.python.org/pypi/mysqlclient)|code-block|syntax|javascript|1959381|​|1959382|1959383|然后通过pip安装程序安装这个whl。按住Shift键并在已下载文件夹中单击鼠标右键，然后选择Open+powershell+here。然后使用以下命令安装：pip+install+package_name.whl|offset|length|style|CODE|1959384|1959385|entityMap^0|0|0|0|0|0|0|1B|K|27|S|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$]]|$1|E|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|N|3|O|5|D|7|12|8|@$P|13|Q|14|R|S]|$P|15|Q|16|R|S]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|V|$]]

<ol>
<li>Download from this

<ul>
<li>Python 2.7: <a href="https://pypi.python.org/pypi/mysqlclient/1.3.6" rel="nofollow noreferrer">https://pypi.python.org/pypi/mysqlclient/1.3.9</a></li>
<li>Python 3.6: <a href="https://pypi.python.org/pypi/mysqlclient" rel="nofollow noreferrer">https://pypi.python.org/pypi/mysqlclient</a></li>
</ul></li>
<li>Then install this whl by pip installer. Shift + right click in Downloaded folder and choose <code>Open powershell here</code>. Then install using command: <code>pip install package_name.whl</code></li>
</ol>

blocks|key|781517|text|最简单的工作解决方案：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|781518|从下面的链接下载MySQL连接器C+6.0.2并安装。|781519|http://dev.mysql.com/downloads/connector/c/6.0.html#downloads|781520|安装MySQL连接器C+6.0.2后，将文件夹"MySQL连接器C+6.0.2“从"C:\Program+Files\MySQL”复制到"C:\Program+Files+(x86)\MySQL“。|781521|然后键入|781522|pip+install+MySQL-python|code-block|syntax|javascript|781523|它肯定能行得通。|781524|entityMap|0|LINK|mutability|MUTABLE|url^0|0|B|0|0|0|1P|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|J|3|K|5|6|7|19|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1A|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1B|8|@]|D|@]|E|$Q|R]]|$1|S|3|T|5|6|7|1C|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|I]]]]

Simplest working solution:

Download the MySQL Connector C 6.0.2 from below link and Install.

<a href="http://dev.mysql.com/downloads/connector/c/6.0.html#downloads" rel="nofollow noreferrer">http://dev.mysql.com/downloads/connector/c/6.0.html#downloads</a>

After installing the MySQL Connector C 6.0.2, copy the folder "MySQL Connector C 6.0.2" from "C:\Program Files\MySQL" to "C:\Program Files (x86)\MySQL".

Then type

<pre><code>pip install MySQL-python
</code></pre>

It will definitely work.

blocks|key|781546|text|building+'_mysql'+extension
creating+build\temp.win-amd64-2.7
creating+build\temp.win-amd64-2.7\Release
C:\Users\TimHuang\AppData\Local\Programs\Common\Microsoft\Visual+C%2B%2B+for+Python\9.0\VC\Bin\amd64\cl.exe+/c+/nologo+/Ox+/MD+/W3+/GS-+/DNDEBUG+-Dversion_info=(1,2,5,'final',1)+-D__version__=1.2.5+"-IC:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2\include"+-Ic:\python27\include+-Ic:\python27\PC+/Tc_mysql.c+/Fobuild\temp.win-amd64-2.7\Release\_mysql.obj+/Zl
_mysql.c
_mysql.c(42)+:+fatal+error+C1083:+Cannot+open+include+file:+'config-win.h':+No+such+file+or+directory|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|781547|如果您在尝试pip+install+mysql-python时看到以下内容，则最简单的方法是复制|unstyled|offset|length|style|CODE|781548|C:\Program+Files\MySQL\MySQL+Connector+C+6.0.2到C:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2|781549|我试着创建符号链接，但Windows总是抛给我C:\WINDOWS\system32>mklink+/d+"C:\Program+Files+(x86)\MySQL\MySQL+Connector+C+6.0.2\include"+"C:\Program+Files\MySQL\MySQL+Connector+C+6.0.2\include"+The+system+cannot+find+the+path+specified.|781550|entityMap^0|0|6|O|0|0|1A|1B|1G|0|N|5C|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@$G|S|H|T|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@$G|V|H|W|I|J]|$G|X|H|Y|I|J]]|9|@]|A|$]]|$1|M|3|N|5|F|7|Z|8|@$G|10|H|11|I|J]]|9|@]|A|$]]|$1|O|3|-4|5|F|7|12|8|@]|9|@]|A|$]]]|P|$]]

<pre><code>building '_mysql' extension
creating build\temp.win-amd64-2.7
creating build\temp.win-amd64-2.7\Release
C:\Users\TimHuang\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\Bin\amd64\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" -Ic:\python27\include -Ic:\python27\PC /Tc_mysql.c /Fobuild\temp.win-amd64-2.7\Release\_mysql.obj /Zl
_mysql.c
_mysql.c(42) : fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory
</code></pre>

If you see this when you try <code>pip install mysql-python</code>, the easiest way is to copy 

<code>C:\Program Files\MySQL\MySQL Connector C 6.0.2</code>
to <code>C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2</code>

I tried to create the symbolic link but Windows keeps throwing me
<code>C:\WINDOWS\system32&gt;mklink /d "C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "C:\Program Files\MySQL\MySQL Connector C 6.0.2\include"
The system cannot find the path specified.</code>

blocks|key|2190103|text|从https://dev.mysql.com/downloads/connector/c/6.0.html下载连接器的版本，对于我的情况，我安装了64位的连接器，而我的python是32位的。所以我不得不把MySQL从程序文件复制到程序文件(86)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2190104|entityMap^0|1|1G|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Download the version of Connector from <code>https://dev.mysql.com/downloads/connector/c/6.0.html</code>
For my case I had installed 64 bit of connector and my python was 32 bit. So I had to copy MySQL from program files to Program Files(86)

blocks|key|781649|text|Window10的步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|781650|根据python版本和硬件规格，转到https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python|offset|length|style|CODE|781651|Download正确的版本:就我而言，mysqlclient‑1.4.2‑cp37‑cp37m‑win32.whl适用于python3.7和英特尔CPU。|unordered-list-item|781652|
|781653|在您的环境仍处于激活状态时，请转到下载文件夹并运行pip+install+mysqlclient-1.4.2-cp37-cp37m-win32.whl|781654|781655|entityMap^0|0|I|1K|0|J|12|0|0|P|1E|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|J|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|Q|$]]

Steps for Window10:

<ul>
<li>Go to <code>https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python</code></li>
<li>Download the right version according to python version and hardware specs: for my case, <code>mysqlclient‑1.4.2‑cp37‑cp37m‑win32.whl</code> works for python3.7 and Intel CPU.</li>
<li>While your env is still activated, go to the download folder and run <code>pip install mysqlclient-1.4.2-cp37-cp37m-win32.whl</code></li>
</ul>

I'm trying to install mysql-python in a virtualenv using pip on windows. At first, I was getting the same error <a href="https://stackoverflow.com/questions/1706989/setting-up-virtualenv-for-django-development-on-windows">reported here</a>, but the answer there worked for me too. Now I'm getting this following error:

<pre><code>_mysql.c(34) : Fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory
</code></pre>

If I symlink (Win7) to my regular (not the virtualenv's) python's site-packages/MySQLdb dir I get 

<pre><code>Error loading MySQLdb module: No module named _mysql
</code></pre>

I'm rather at a loss here. Any pointers?

"Cannot open include file: 'config-win.h': No such file or directory" while installing mysql-python

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我正在尝试使用windows上的pip在一个虚拟环境中安装mysql-python。起初，我得到了相同的错误，但那里的答案也适用于我。现在我得到以下错误：_mysql.c(34) : Fatal error C1083: Cannot open include file: 'config-win.h': No such...

问安装mysql-python时“无法打开包含文件：'config-win.h'：没有这样的文件或目录”
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问安装mysql-python时“无法打开包含文件：'config-win.h'：没有这样的文件或目录”EN