python - Python Mysql 1.2.5 安装不起作用 Pycharm
问题描述
我一直在尝试从 Pycharm 安装 Mysql-Python 1.2.5。这是我的点子列表: https ://prnt.sc/u6ccac
我的python版本:Python 3.7.3 已经安装了mysqlclient: https ://prnt.sc/u6cesn
仍然无法安装 Mysql-Python。这是截图的错误: 在此处输入图片描述
这是命令输出:
Collecting MySQL-python
Using cached MySQL-python-1.2.5.zip (108 kB)
Building wheels for collected packages: MySQL-python
Building wheel for MySQL-python (setup.py): started
Building wheel for MySQL-python (setup.py): finished with status 'error'
Running setup.py clean for MySQL-python
Failed to build MySQL-python
Installing collected packages: MySQL-python
Running setup.py install for MySQL-python: started
Running setup.py install for MySQL-python: finished with status 'error'
DEPRECATION: The -b/--build/--build-dir/--build-directory option is deprecated. pip 20.3 will remove support for this functionality. A possible replacement is use the TMPDIR/TEMP/TMP environment variable, possibly combined with --no-clean. You can find discussion regarding this at https://github.com/pypa/pip/issues/8333.
ERROR: Command errored out with exit status 1:
command: 'C:\Program Files\Python37\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"'; __file__='"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Users\poison\AppData\Local\Temp\pip-wheel-jfgonzmq'
cwd: C:\Users\poison\AppData\Local\Temp\pycharm-packaging\mysql-python\
Complete output (117 lines):
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win-amd64-3.7
copying _mysql_exceptions.py -> build\lib.win-amd64-3.7
creating build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\converters.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\connections.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\release.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\times.py -> build\lib.win-amd64-3.7\MySQLdb
creating build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.7\MySQLdb\constants
running build_ext
building '_mysql' extension
creating build\temp.win-amd64-3.7
creating build\temp.win-amd64-3.7\Release
C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -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:\Program Files\Python37\include" "-IC:\Program Files\Python37\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\include" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" /Tc_mysql.c /Fobuild\temp.win-amd64-3.7\Release\_mysql.obj /Zl
_mysql.c
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(192): warning C4005: 'isnan': macro redefinition
C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt\corecrt_math.h(276): note: see previous definition of 'isnan'
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(203): warning C4005: 'SIZEOF_OFF_T': macro redefinition
C:\Program Files\Python37\include\pyconfig.h(291): note: see previous definition of 'SIZEOF_OFF_T'
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(301): warning C4005: 'HAVE_STDDEF_H': macro redefinition
C:\Program Files\Python37\include\pyconfig.h(580): note: see previous definition of 'HAVE_STDDEF_H'
_mysql.c(287): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(297): warning C4090: '=': different 'const' qualifiers
_mysql.c(317): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(327): warning C4090: '=': different 'const' qualifiers
_mysql.c(470): warning C4244: 'initializing': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(623): warning C4090: '=': different 'const' qualifiers
_mysql.c(624): warning C4090: '=': different 'const' qualifiers
_mysql.c(625): warning C4090: '=': different 'const' qualifiers
_mysql.c(626): warning C4090: '=': different 'const' qualifiers
_mysql.c(627): warning C4090: '=': different 'const' qualifiers
_mysql.c(1118): warning C4090: '=': different 'const' qualifiers
_mysql.c(1161): warning C4090: '=': different 'const' qualifiers
_mysql.c(1162): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(1165): warning C4090: '=': different 'const' qualifiers
_mysql.c(1274): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(1466): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1468): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1504): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1506): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1532): warning C4018: '<': signed/unsigned mismatch
_mysql.c(2238): warning C4311: 'type cast': pointer truncation from '_mysql_ConnectionObject *' to 'long'
_mysql.c(2241): warning C4311: 'type cast': pointer truncation from '_mysql_ConnectionObject *' to 'long'
_mysql.c(2302): warning C4244: 'function': conversion from '__int64' to 'long', possible loss of data
_mysql.c(2321): warning C4311: 'type cast': pointer truncation from '_mysql_ResultObject *' to 'long'
C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\bin\HostX86\x64\link.exe /nologo /INCREMENTAL:NO /LTCG /DLL /MANIFEST:EMBED,ID=2 /MANIFESTUAC:NO "/LIBPATH:C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\lib\opt" "/LIBPATH:C:\Program Files\Python37\libs" "/LIBPATH:C:\Program Files\Python37\PCbuild\amd64" "/LIBPATH:C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\lib\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\lib\um\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\ucrt\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\um\x64" kernel32.lib advapi32.lib wsock32.lib mysqlclient.lib /EXPORT:PyInit__mysql build\temp.win-amd64-3.7\Release\_mysql.obj /OUT:build\lib.win-amd64-3.7\_mysql.cp37-win_amd64.pyd /IMPLIB:build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.lib
Creating library build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.lib and object build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.exp
_mysql.obj : error LNK2001: unresolved external symbol __security_check_cookie
_mysql.obj : error LNK2001: unresolved external symbol mysql_field_count
_mysql.obj : error LNK2001: unresolved external symbol mysql_warning_count
_mysql.obj : error LNK2001: unresolved external symbol mysql_num_rows
_mysql.obj : error LNK2001: unresolved external symbol mysql_shutdown
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_query
_mysql.obj : error LNK2001: unresolved external symbol mysql_ping
_mysql.obj : error LNK2001: unresolved external symbol mysql_stat
_mysql.obj : error LNK2001: unresolved external symbol mysql_insert_id
_mysql.obj : error LNK2001: unresolved external symbol mysql_next_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_ssl_set
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_proto_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_store_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_change_user
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_character_set_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_commit
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_server_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_data_seek
_mysql.obj : error LNK2001: unresolved external symbol mysql_errno
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_connect
_mysql.obj : error LNK2001: unresolved external symbol mysql_rollback
_mysql.obj : error LNK2001: unresolved external symbol mysql_options
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_host_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_lengths
_mysql.obj : error LNK2001: unresolved external symbol __imp_strncpy
_mysql.obj : error LNK2001: unresolved external symbol mysql_affected_rows
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_escape_string
_mysql.obj : error LNK2001: unresolved external symbol mysql_debug
_mysql.obj : error LNK2001: unresolved external symbol mysql_set_server_option
_mysql.obj : error LNK2001: unresolved external symbol mysql_set_character_set
_mysql.obj : error LNK2001: unresolved external symbol mysql_dump_debug_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_row_tell
_mysql.obj : error LNK2001: unresolved external symbol mysql_close
_mysql.obj : error LNK2001: unresolved external symbol mysql_server_end
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_client_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_server_init
_mysql.obj : error LNK2001: unresolved external symbol __imp___stdio_common_vsprintf
_mysql.obj : error LNK2001: unresolved external symbol mysql_free_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_row
_mysql.obj : error LNK2001: unresolved external symbol mysql_thread_safe
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_fields
_mysql.obj : error LNK2001: unresolved external symbol mysql_character_set_name
_mysql.obj : error LNK2001: unresolved external symbol mysql_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_escape_string
_mysql.obj : error LNK2001: unresolved external symbol mysql_num_fields
_mysql.obj : error LNK2001: unresolved external symbol mysql_kill
_mysql.obj : error LNK2001: unresolved external symbol __imp_strncat
_mysql.obj : error LNK2001: unresolved external symbol mysql_use_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_select_db
_mysql.obj : error LNK2001: unresolved external symbol mysql_sqlstate
_mysql.obj : error LNK2001: unresolved external symbol mysql_init
_mysql.obj : error LNK2001: unresolved external symbol mysql_row_seek
_mysql.obj : error LNK2001: unresolved external symbol mysql_autocommit
_mysql.obj : error LNK2001: unresolved external symbol mysql_error
_mysql.obj : error LNK2001: unresolved external symbol mysql_thread_id
LINK : error LNK2001: unresolved external symbol _DllMainCRTStartup
build\lib.win-amd64-3.7\_mysql.cp37-win_amd64.pyd : fatal error LNK1120: 56 unresolved externals
error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\BuildTools\\VC\\Tools\\MSVC\\14.24.28314\\bin\\HostX86\\x64\\link.exe' failed with exit status 1120
----------------------------------------
ERROR: Failed building wheel for MySQL-python
DEPRECATION: Could not build wheels for MySQL-python which do not use PEP 517. pip will fall back to legacy 'setup.py install' for these. pip 21.0 will remove support for this functionality. A possible replacement is to fix the wheel build issue reported above. You can find discussion regarding this at https://github.com/pypa/pip/issues/8368.
ERROR: Command errored out with exit status 1:
command: 'C:\Program Files\Python37\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"'; __file__='"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\poison\AppData\Local\Temp\pip-record-3w457344\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\Program Files\Python37\Include\MySQL-python'
cwd: C:\Users\poison\AppData\Local\Temp\pycharm-packaging\mysql-python\
Complete output (117 lines):
running install
running build
running build_py
creating build
creating build\lib.win-amd64-3.7
copying _mysql_exceptions.py -> build\lib.win-amd64-3.7
creating build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\__init__.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\converters.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\connections.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\cursors.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\release.py -> build\lib.win-amd64-3.7\MySQLdb
copying MySQLdb\times.py -> build\lib.win-amd64-3.7\MySQLdb
creating build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.7\MySQLdb\constants
copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.7\MySQLdb\constants
running build_ext
building '_mysql' extension
creating build\temp.win-amd64-3.7
creating build\temp.win-amd64-3.7\Release
C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -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:\Program Files\Python37\include" "-IC:\Program Files\Python37\include" "-IC:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\include" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" /Tc_mysql.c /Fobuild\temp.win-amd64-3.7\Release\_mysql.obj /Zl
_mysql.c
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(192): warning C4005: 'isnan': macro redefinition
C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt\corecrt_math.h(276): note: see previous definition of 'isnan'
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(203): warning C4005: 'SIZEOF_OFF_T': macro redefinition
C:\Program Files\Python37\include\pyconfig.h(291): note: see previous definition of 'SIZEOF_OFF_T'
C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include\config-win.h(301): warning C4005: 'HAVE_STDDEF_H': macro redefinition
C:\Program Files\Python37\include\pyconfig.h(580): note: see previous definition of 'HAVE_STDDEF_H'
_mysql.c(287): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(297): warning C4090: '=': different 'const' qualifiers
_mysql.c(317): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(327): warning C4090: '=': different 'const' qualifiers
_mysql.c(470): warning C4244: 'initializing': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(623): warning C4090: '=': different 'const' qualifiers
_mysql.c(624): warning C4090: '=': different 'const' qualifiers
_mysql.c(625): warning C4090: '=': different 'const' qualifiers
_mysql.c(626): warning C4090: '=': different 'const' qualifiers
_mysql.c(627): warning C4090: '=': different 'const' qualifiers
_mysql.c(1118): warning C4090: '=': different 'const' qualifiers
_mysql.c(1161): warning C4090: '=': different 'const' qualifiers
_mysql.c(1162): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(1165): warning C4090: '=': different 'const' qualifiers
_mysql.c(1274): warning C4244: '=': conversion from 'Py_ssize_t' to 'int', possible loss of data
_mysql.c(1466): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1468): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1504): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1506): warning C4267: '=': conversion from 'size_t' to 'int', possible loss of data
_mysql.c(1532): warning C4018: '<': signed/unsigned mismatch
_mysql.c(2238): warning C4311: 'type cast': pointer truncation from '_mysql_ConnectionObject *' to 'long'
_mysql.c(2241): warning C4311: 'type cast': pointer truncation from '_mysql_ConnectionObject *' to 'long'
_mysql.c(2302): warning C4244: 'function': conversion from '__int64' to 'long', possible loss of data
_mysql.c(2321): warning C4311: 'type cast': pointer truncation from '_mysql_ResultObject *' to 'long'
C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\bin\HostX86\x64\link.exe /nologo /INCREMENTAL:NO /LTCG /DLL /MANIFEST:EMBED,ID=2 /MANIFESTUAC:NO "/LIBPATH:C:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\lib\opt" "/LIBPATH:C:\Program Files\Python37\libs" "/LIBPATH:C:\Program Files\Python37\PCbuild\amd64" "/LIBPATH:C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\VC\Tools\MSVC\14.24.28314\lib\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\lib\um\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\ucrt\x64" "/LIBPATH:C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\um\x64" kernel32.lib advapi32.lib wsock32.lib mysqlclient.lib /EXPORT:PyInit__mysql build\temp.win-amd64-3.7\Release\_mysql.obj /OUT:build\lib.win-amd64-3.7\_mysql.cp37-win_amd64.pyd /IMPLIB:build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.lib
Creating library build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.lib and object build\temp.win-amd64-3.7\Release\_mysql.cp37-win_amd64.exp
_mysql.obj : error LNK2001: unresolved external symbol __security_check_cookie
_mysql.obj : error LNK2001: unresolved external symbol mysql_field_count
_mysql.obj : error LNK2001: unresolved external symbol mysql_warning_count
_mysql.obj : error LNK2001: unresolved external symbol mysql_num_rows
_mysql.obj : error LNK2001: unresolved external symbol mysql_shutdown
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_query
_mysql.obj : error LNK2001: unresolved external symbol mysql_ping
_mysql.obj : error LNK2001: unresolved external symbol mysql_stat
_mysql.obj : error LNK2001: unresolved external symbol mysql_insert_id
_mysql.obj : error LNK2001: unresolved external symbol mysql_next_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_ssl_set
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_proto_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_store_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_change_user
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_character_set_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_commit
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_server_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_data_seek
_mysql.obj : error LNK2001: unresolved external symbol mysql_errno
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_connect
_mysql.obj : error LNK2001: unresolved external symbol mysql_rollback
_mysql.obj : error LNK2001: unresolved external symbol mysql_options
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_host_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_lengths
_mysql.obj : error LNK2001: unresolved external symbol __imp_strncpy
_mysql.obj : error LNK2001: unresolved external symbol mysql_affected_rows
_mysql.obj : error LNK2001: unresolved external symbol mysql_real_escape_string
_mysql.obj : error LNK2001: unresolved external symbol mysql_debug
_mysql.obj : error LNK2001: unresolved external symbol mysql_set_server_option
_mysql.obj : error LNK2001: unresolved external symbol mysql_set_character_set
_mysql.obj : error LNK2001: unresolved external symbol mysql_dump_debug_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_row_tell
_mysql.obj : error LNK2001: unresolved external symbol mysql_close
_mysql.obj : error LNK2001: unresolved external symbol mysql_server_end
_mysql.obj : error LNK2001: unresolved external symbol mysql_get_client_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_server_init
_mysql.obj : error LNK2001: unresolved external symbol __imp___stdio_common_vsprintf
_mysql.obj : error LNK2001: unresolved external symbol mysql_free_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_row
_mysql.obj : error LNK2001: unresolved external symbol mysql_thread_safe
_mysql.obj : error LNK2001: unresolved external symbol mysql_fetch_fields
_mysql.obj : error LNK2001: unresolved external symbol mysql_character_set_name
_mysql.obj : error LNK2001: unresolved external symbol mysql_info
_mysql.obj : error LNK2001: unresolved external symbol mysql_escape_string
_mysql.obj : error LNK2001: unresolved external symbol mysql_num_fields
_mysql.obj : error LNK2001: unresolved external symbol mysql_kill
_mysql.obj : error LNK2001: unresolved external symbol __imp_strncat
_mysql.obj : error LNK2001: unresolved external symbol mysql_use_result
_mysql.obj : error LNK2001: unresolved external symbol mysql_select_db
_mysql.obj : error LNK2001: unresolved external symbol mysql_sqlstate
_mysql.obj : error LNK2001: unresolved external symbol mysql_init
_mysql.obj : error LNK2001: unresolved external symbol mysql_row_seek
_mysql.obj : error LNK2001: unresolved external symbol mysql_autocommit
_mysql.obj : error LNK2001: unresolved external symbol mysql_error
_mysql.obj : error LNK2001: unresolved external symbol mysql_thread_id
LINK : error LNK2001: unresolved external symbol _DllMainCRTStartup
build\lib.win-amd64-3.7\_mysql.cp37-win_amd64.pyd : fatal error LNK1120: 56 unresolved externals
error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\BuildTools\\VC\\Tools\\MSVC\\14.24.28314\\bin\\HostX86\\x64\\link.exe' failed with exit status 1120
----------------------------------------
ERROR: Command errored out with exit status 1: 'C:\Program Files\Python37\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"'; __file__='"'"'C:\\Users\\poison\\AppData\\Local\\Temp\\pycharm-packaging\\mysql-python\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\poison\AppData\Local\Temp\pip-record-3w457344\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\Program Files\Python37\Include\MySQL-python' Check the logs for full command output.
解决方案
尝试在那里安装其他选项,例如 pymysql、mysql-connector 和 mysql-connector-python
或使用点子
pip install pymysql
pip install mysql-connector
pip install mysql-connector-python
笔记:
上面列出的所有模块都是一样的
推荐阅读
- javascript - JSON api 响应在浏览器中有奇怪的行为
- python - 调用 os.system(command) 而不弹出
- sql - #在 Access 中解析字符串时从 `Switch` 抛出错误
- excel - 如何添加嵌套的 For/Next 循环来分割文件切割?
- postgresql - 可以将 postgresql 配置为将所有标识符视为区分大小写吗?
- dart - 如何使用 Dart 从地图制作流
- c# - 我正在尝试使用 SQL Server 从 Visual Studio 显示数据网格
- android - 在imageview中设置后如何以编程方式更改色调颜色
- python - 拆分句子中具有特殊“.{{”外观的文本
- hashicorp-vault - 如何使用 Jenkins 配置 Approle 以从保险库生成 STS 令牌