LoginSignup
@Taaayu_T (Yuta Tsuchiya)

Are you sure you want to delete the question?

Leaving a resolved question undeleted may help others!

Anaconda仮想環境にpip install でmysqlclientがインストールできない。

Q&A

Closed

PythonDjangopipAnacondamysqlclient

解決したいこと

anaconda仮想環境でターミナルから pip install mysqlclient を実行すると以下のエラーになりインストールできません。
解決方法がわからず質問させて頂きました。

エラーの発生環境

Mac M1
macOS Big Sur 11.5.2
pip 21.2.4

発生している問題・エラー

Collecting mysqlclient
  Using cached mysqlclient-2.0.3.tar.gz (88 kB)
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: /opt/anaconda3/envs/djangoenv/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/setup.py'"'"'; __file__='"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/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 /private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-wheel-i7hxqazh
       cwd: /private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/
  Complete output (43 lines):
  mysql_config --version
  ['8.0.26']
  mysql_config --libs
  ['-L/opt/homebrew/Cellar/mysql/8.0.26/lib', '-lmysqlclient', '-lz', '-lzstd', '-lssl', '-lcrypto', '-lresolv']
  mysql_config --cflags
  ['-I/opt/homebrew/Cellar/mysql/8.0.26/include/mysql']
  ext_options:
    library_dirs: ['/opt/homebrew/Cellar/mysql/8.0.26/lib']
    libraries: ['mysqlclient', 'zstd', 'resolv']
    extra_compile_args: ['-std=c99']
    extra_link_args: []
    include_dirs: ['/opt/homebrew/Cellar/mysql/8.0.26/include/mysql']
    extra_objects: []
    define_macros: [('version_info', "(2,0,3,'final',0)"), ('__version__', '2.0.3')]
  running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.macosx-10.9-x86_64-3.8
  creating build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/__init__.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/_exceptions.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/connections.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/converters.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/cursors.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/release.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  copying MySQLdb/times.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
  creating build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/CR.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/ER.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
  running build_ext
  building 'MySQLdb._mysql' extension
  creating build/temp.macosx-10.9-x86_64-3.8
  creating build/temp.macosx-10.9-x86_64-3.8/MySQLdb
  gcc -Wno-unused-result -Wsign-compare -Wunreachable-code -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -I/opt/anaconda3/envs/djangoenv/include -arch x86_64 -I/opt/anaconda3/envs/djangoenv/include -arch x86_64 -Dversion_info=(2,0,3,'final',0) -D__version__=2.0.3 -I/opt/homebrew/Cellar/mysql/8.0.26/include/mysql -I/opt/anaconda3/envs/djangoenv/include/python3.8 -c MySQLdb/_mysql.c -o build/temp.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.o -std=c99
  gcc -bundle -undefined dynamic_lookup -L/opt/anaconda3/envs/djangoenv/lib -arch x86_64 -L/opt/anaconda3/envs/djangoenv/lib -arch x86_64 -arch x86_64 build/temp.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.o -L/opt/homebrew/Cellar/mysql/8.0.26/lib -lmysqlclient -lzstd -lresolv -o build/lib.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.cpython-38-darwin.so
  ld: library not found for -lzstd
  clang: error: linker command failed with exit code 1 (use -v to see invocation)
  error: command 'gcc' failed with exit status 1
  ----------------------------------------
  ERROR: Failed building wheel for mysqlclient
  Running setup.py clean for mysqlclient
Failed to build mysqlclient
Installing collected packages: mysqlclient
    Running setup.py install for mysqlclient ... error
    ERROR: Command errored out with exit status 1:
     command: /opt/anaconda3/envs/djangoenv/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/setup.py'"'"'; __file__='"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-record-asneljs6/install-record.txt --single-version-externally-managed --compile --install-headers /opt/anaconda3/envs/djangoenv/include/python3.8/mysqlclient
         cwd: /private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/
    Complete output (43 lines):
    mysql_config --version
    ['8.0.26']
    mysql_config --libs
    ['-L/opt/homebrew/Cellar/mysql/8.0.26/lib', '-lmysqlclient', '-lz', '-lzstd', '-lssl', '-lcrypto', '-lresolv']
    mysql_config --cflags
    ['-I/opt/homebrew/Cellar/mysql/8.0.26/include/mysql']
    ext_options:
      library_dirs: ['/opt/homebrew/Cellar/mysql/8.0.26/lib']
      libraries: ['mysqlclient', 'zstd', 'resolv']
      extra_compile_args: ['-std=c99']
      extra_link_args: []
      include_dirs: ['/opt/homebrew/Cellar/mysql/8.0.26/include/mysql']
      extra_objects: []
      define_macros: [('version_info', "(2,0,3,'final',0)"), ('__version__', '2.0.3')]
    running install
    running build
    running build_py
    creating build
    creating build/lib.macosx-10.9-x86_64-3.8
    creating build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/__init__.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/_exceptions.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/connections.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/converters.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/cursors.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/release.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    copying MySQLdb/times.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb
    creating build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/CR.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/ER.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.9-x86_64-3.8/MySQLdb/constants
    running build_ext
    building 'MySQLdb._mysql' extension
    creating build/temp.macosx-10.9-x86_64-3.8
    creating build/temp.macosx-10.9-x86_64-3.8/MySQLdb
    gcc -Wno-unused-result -Wsign-compare -Wunreachable-code -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -I/opt/anaconda3/envs/djangoenv/include -arch x86_64 -I/opt/anaconda3/envs/djangoenv/include -arch x86_64 -Dversion_info=(2,0,3,'final',0) -D__version__=2.0.3 -I/opt/homebrew/Cellar/mysql/8.0.26/include/mysql -I/opt/anaconda3/envs/djangoenv/include/python3.8 -c MySQLdb/_mysql.c -o build/temp.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.o -std=c99
    gcc -bundle -undefined dynamic_lookup -L/opt/anaconda3/envs/djangoenv/lib -arch x86_64 -L/opt/anaconda3/envs/djangoenv/lib -arch x86_64 -arch x86_64 build/temp.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.o -L/opt/homebrew/Cellar/mysql/8.0.26/lib -lmysqlclient -lzstd -lresolv -o build/lib.macosx-10.9-x86_64-3.8/MySQLdb/_mysql.cpython-38-darwin.so
    ld: library not found for -lzstd
    clang: error: linker command failed with exit code 1 (use -v to see invocation)
    error: command 'gcc' failed with exit status 1
    ----------------------------------------
ERROR: Command errored out with exit status 1: /opt/anaconda3/envs/djangoenv/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/setup.py'"'"'; __file__='"'"'/private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-install-zyms_pa3/mysqlclient_f088c14332324d2f9413009f022b3ef6/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/dh/7z6pw5_15xg9qn84hp55_xfh0000gn/T/pip-record-asneljs6/install-record.txt --single-version-externally-managed --compile --install-headers /opt/anaconda3/envs/djangoenv/include/python3.8/mysqlclient Check the logs for full command output.
0 likes

1Answer

Your answer might help someone💌

LoginSign Up