{"id":449,"date":"2015-03-21T23:03:13","date_gmt":"2015-03-21T14:03:13","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2015\/03\/21\/windowspython27virtualenv_mysql-python_125\/"},"modified":"2015-03-21T23:03:13","modified_gmt":"2015-03-21T14:03:13","slug":"windowspython27virtualenv_mysql-python_125","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2015\/03\/21\/windowspython27virtualenv_mysql-python_125\/","title":{"rendered":"Windows\u3001Python2.7\u3001VirtualEnv \u3067 MySql-Python 1.2.5 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u6642\u306e\u30a8\u30e9\u30fc\u306e\u8a71"},"content":{"rendered":"<p>VirtualEnv \u3092\u8d77\u52d5\u3057\u3066\u3001mysql-python 1.2.5 \u306e \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u308b\u3002<\/p>\n<pre class=\"prettyprint linenums\">(phrase_env) c:\\Programs\\venv\\phrase_env&gt;pip install mysql-python==1.2.5<\/pre>\n<p>\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3001VisualC++\u306e\u30b3\u30f3\u30d1\u30a4\u30e9\u304c\u5fc5\u8981\u3060\uff01\u7684\u306a\u30ed\u30b0\u304c\u3001\u4ee5\u4e0b\u306eURL\u3068\u3068\u3082\u306b\u306f\u304b\u308c\u305f\u305f\u3081\u3001\u6307\u793a\u306b\u5f93\u3044\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n<p><strong>Microsoft Visual C++ Compiler for Python 2.7<\/strong><\/p>\n<p><a title=\"https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=44266\" href=\"https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=44266\">https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=44266<\/a><\/p>\n<p>&#160;<\/p>\n<p><a href=\"http:\/\/www.amazon.co.jp\/gp\/product\/B00J8DSQGA\/ref=as_li_ss_il?ie=UTF8&amp;camp=247&amp;creative=7399&amp;creativeASIN=B00J8DSQGA&amp;linkCode=as2&amp;tag=typea09-22\"><img decoding=\"async\" border=\"0\" src=\"http:\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=B00J8DSQGA&amp;Format=_SL160_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=typea09-22\" \/><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border-top-style: none !important; border-bottom-style: none !important; border-right-style: none !important; margin: 0px; border-left-style: none !important\" border=\"0\" alt=\"\" src=\"http:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=typea09-22&amp;l=as2&amp;o=9&amp;a=B00J8DSQGA\" width=\"1\" height=\"1\" \/> <\/p>\n<p>\u6c17\u3092\u53d6\u308a\u76f4\u3057\u3066\u518d\u30c1\u30e3\u30ec\u30f3\u30b8\u3002<\/p>\n<p>\u306f\u3044\u3002\u4eca\u5ea6\u306f\u3001\u30d8\u30c3\u30c0\u30d5\u30a1\u30a4\u30eb\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u7684\u306a\u30a8\u30e9\u30fc\u3002<\/p>\n<pre class=\"prettyprint linenums\">(phrase_env) c:\\Programs\\venv\\phrase_env&gt;pip install mysql-python==1.2.5\r\nCollecting mysql-python==1.2.5\r\n  Using cached MySQL-python-1.2.5.zip\r\nInstalling collected packages: mysql-python\r\n  Running setup.py install for mysql-python\r\n    building '_mysql' extension\r\n    C:\\Users\\piroto\\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 &quot;-IC:\\Program Files (x86)\\MySQL\\MySQL Connector C 6.0.2\\include&quot; -IC:\\python27\\include -Ic:\\Programs\\venv\\phrase_env\\PC \/Tc_mysql.c \/Fobuild\\temp.win-amd64-2.7\\Release\\_mysql.obj \/Zl    _mysql.c    _mysql.c(42)\r\n     : (\u7565)\r\n    fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory    error: command 'C:\\\\Users\\\\piroto\\\\AppData\\\\Local\\\\Programs\\\\Common\\\\Microsoft\\\\Visual C++ for Python\\\\9.0\\\\VC\\\\Bin\\\\amd64\\\\cl.exe' failed with exit status 2    Complete output from command c:\\Programs\\venv\\phrase_env\\Scripts\\python.exe -c &quot;import setuptools, tokenize;__file__='c:\\\\users\\\\piroto\\\\appdata\\\\local\\\\temp\\\\pip-build-jmdxif\\\\mysql-python\\\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\\r\\n', '\\n'), __file__, 'exec'))&quot; install --record c:\\users\\piroto\\appdata\\local\\temp\\pip-qwlwk5-record\\install-record.txt --single-version-externally-managed --compile --install-headers c:\\Programs\\venv\\phrase_env\\include\\site\\python2.7:    running install\r\n    running build\r\n    creating build\\temp.win-amd64-2.7\r\n    creating build\\temp.win-amd64-2.7\\Release\r\n    C:\\Users\\piroto\\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 &quot;-IC:\\Program Files (x86)\\MySQL\\MySQL Connector C 6.0.2\\include&quot; -IC:\\python27\\include -Ic:\\Programs\\venv\\phrase_env\\PC \/Tc_mysql.c \/Fobuild\\temp.win-amd64-2.7\\Release\\_mysql.obj \/Zl\r\n    _mysql.c\r\n    _mysql.c(42) : fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory\r\n    error: command 'C:\\\\Users\\\\piroto\\\\AppData\\\\Local\\\\Programs\\\\Common\\\\Microsoft\\\\Visual C++ for Python\\\\9.0\\\\VC\\\\Bin\\\\amd64\\\\cl.exe' failed with exit status 2\r\n    ----------------------------------------\r\n    Command &quot;c:\\Programs\\venv\\phrase_env\\Scripts\\python.exe -c &quot;import setuptools, tokenize;__file__='c:\\\\users\\\\piroto\\\\appdata\\\\local\\\\temp\\\\pip-build-jmdxif\\\\mysql-python\\\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\\r\\n', '\\n'), __file__, 'exec'))&quot; install --record c:\\users\\piroto\\appdata\\local\\temp\\pip-qwlwk5-record\\install-record.txt --single-version-externally-managed --compile --install-headers c:\\Programs\\venv\\phrase_env\\include\\site\\python2.7&quot; failed with error code 1 in c:\\users\\piroto\\appdata\\local\\temp\\pip-build-jmdxif\\mysql-python<\/pre>\n<p>\u3053\u306e\u624b\u306e\u4f5c\u696d\u306f\u3001Linux\u3067\u767a\u751f\u3057\u3066\u3082\u3001\u307e\u307e\u3042\u308b\u3053\u3068\u3068\u601d\u3048\u308b\u306e\u3060\u3051\u308c\u3069\u3001Windows\u3060\u3068\u306a\u305c\u3060\u304c\u306a\u3093\u304b\u4e0d\u5b89\u306b\u306a\u308b\u3002<\/p>\n<p>\u5b89\u5b9a\u306e StackOverflow \u306b\u540c\u3058\u554f\u984c\u304c\u3002<\/p>\n<p><a title=\"http:\/\/stackoverflow.com\/questions\/1972259\/mysql-python-install-problem-using-virtualenv-windows-pip\" href=\"http:\/\/stackoverflow.com\/questions\/1972259\/mysql-python-install-problem-using-virtualenv-windows-pip\">http:\/\/stackoverflow.com\/questions\/1972259\/mysql-python-install-problem-using-virtualenv-windows-pip<\/a><\/p>\n<p>\u4e0a\u306e\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u898b\u3066\u3082\u3089\u3048\u308b\u3068\u308f\u304b\u308b\u306e\u3060\u304c\u3001\u63a2\u3057\u306b\u884c\u3063\u3066\u3044\u308b\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30b3\u30cd\u30af\u30bf\u30fc\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002<\/p>\n<p><a title=\"http:\/\/dev.mysql.com\/downloads\/connector\/c\/6.0.html#downloads\" href=\"http:\/\/dev.mysql.com\/downloads\/connector\/c\/6.0.html#downloads\">http:\/\/dev.mysql.com\/downloads\/connector\/c\/6.0.html#downloads<\/a><\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error02.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql-python_error02\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql-python_error02\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error02_thumb.jpg\" width=\"304\" height=\"192\" \/><\/a><\/p>\n<blockquote>\n<p>had to install the connector for x64 and move the MySql folder from the &#8216;Program Files&#8217; to the &#8216;Program Files (x86)&#8217; directory since that&#8217;s where the build script was looking for it \u2013&#160; <a href=\"http:\/\/stackoverflow.com\/users\/145976\/charlie\">Charlie<\/a> <a href=\"http:\/\/stackoverflow.com\/questions\/1972259\/mysql-python-install-problem-using-virtualenv-windows-pip#comment43228273_16619567\">Dec 9 &#8217;14 at 22:34<\/a><\/p>\n<\/blockquote>\n<p>\u4e00\u70b9\u3001\u6ce8\u610f\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u304c\u3001\u4e0a\u8a18\u306e\u30ed\u30b0\u3092\u898b\u308b\u3068\u308f\u304b\u308b\u306e\u3060\u304c\u3001Program Files (x86) \u4ee5\u4e0b\u306e MySQL \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u63a2\u3057\u306b\u884c\u3063\u3066\u3044\u308b\u305f\u3081\u300164bit \u306eWindows \u306b64bit\u7248\u306e\u30b3\u30cd\u30af\u30bf\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u307e\u307e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u9055\u3046\u5834\u6240(Program FIles \u4ee5\u4e0b)\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3057\u307e\u3046\u305f\u3081\u3001\u4f9d\u7136\u3068\u3057\u3066\u898b\u3064\u304b\u3089\u306a\u3044\u3002<\/p>\n<p>\u304b\u3068\u3044\u3063\u3066\u300132bit\u7248\u306e\u30b3\u30cd\u30af\u30bf\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5225\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u3002<\/p>\n<pre class=\"prettyprint linenums\">    _mysql.obj : error LNK2019: unresolved external symbol mysql_rollback referenced in function _mysql_ConnectionObject_rollback\r\n    _mysql.obj : error LNK2019: unresolved external symbol mysql_next_result referenced in function _mysql_ConnectionObject_next_result\r\n    _mysql.obj : error LNK2019: unresolved external symbol mysql_set_server_option referenced in function _mysql_ConnectionObject_set_server_option\r\n    _mysql.obj : error LNK2019: unresolved external symbol mysql_sqlstate referenced in function _mysql_ConnectionObject_sqlstate<\/pre>\n<p>&#160;<\/p>\n<p>\u3068\u3044\u3046\u308f\u3051\u3067\u300164bit \u306eWindows\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5834\u5408\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u304c\u8d77\u52d5\u3057\u305f\u3089\u3001\u300cCustom\u300d\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u9078\u629e\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u300cProgram Files (x86)\u300d\u304b\u3089 \u300cProgram Files\u300d\u306b\u5909\u66f4\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error01.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql-python_error01\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql-python_error01\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error01_thumb.jpg\" width=\"354\" height=\"277\" \/><\/a><\/p>\n<p>\u4f55\u3068\u304b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6210\u529f\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error03.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"mysql-python_error03\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"mysql-python_error03\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/MySql-Python_137D4\/mysql-python_error03_thumb.jpg\" width=\"357\" height=\"229\" \/><\/a><\/p>\n<p><iframe style=\"height: 240px; width: 120px\" marginheight=\"0\" src=\"http:\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&amp;bc1=FFFFFF&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=typea09-22&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=ss_til&amp;asins=4048686291\" frameborder=\"0\" marginwidth=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>VirtualEnv \u3092\u8d77\u52d5\u3057\u3066\u3001mysql-python 1.2.5 \u306e \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u308b\u3002 (phrase_env) c:\\Programs\\venv\\phrase_env&gt;pip install mysq [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[80,59,20],"tags":[],"class_list":["post-449","post","type-post","status-publish","format-standard","hentry","category-aws-elastic-beanstalk","category-mysql","category-python"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=449"}],"version-history":[{"count":0,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/449\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}