skip to Main Content

I am running into this issue when I try to run pip install mysqlclient. I have already installed all the libraries necessary with brew and/or pip. I tried reinstalling zlib but nothing seems to be working. I tried downloading on brew mysql, mysql-client, etc… but I am not getting any results.

`Collecting mysqlclient
Using cached mysqlclient-2.1.1.tar.gz (88 kB)
Preparing metadata (setup.py) … done
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (setup.py) … error
error: subprocess-exited-with-error

× python setup.py bdist_wheel did not run successfully.
│ exit code: 1
╰─> [43 lines of output] mysql_config –version
[‘8.0.33’] mysql_config –libs
[‘-L/opt/homebrew/Cellar/mysql/8.0.33/lib’, ‘-lmysqlclient’, ‘-lzlib’, ‘-lzstd’, ‘-L/opt/homebrew/opt/[email protected]/lib’, ‘-lssl’, ‘-lcrypto’, ‘-lresolv’] mysql_config –cflags
[‘-I/opt/homebrew/Cellar/mysql/8.0.33/include/mysql’] ext_options:
library_dirs: [‘/opt/homebrew/Cellar/mysql/8.0.33/lib’, ‘/opt/homebrew/opt/[email protected]/lib’] libraries: [‘mysqlclient’, ‘zlib’, ‘resolv’] extra_compile_args: [‘-std=c99’] extra_link_args: [] include_dirs: [‘/opt/homebrew/Cellar/mysql/8.0.33/include/mysql’] extra_objects: [] define_macros: [(‘version_info’, "(2,1,1,’final’,0)"), (‘version‘, ‘2.1.1’)] running bdist_wheel
running build
running build_py
creating build
creating build/lib.macosx-10.9-universal2-cpython-311
creating build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/init.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/exceptions.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/connections.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/converters.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/cursors.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/release.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
copying MySQLdb/times.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb
creating build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/init.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/constants
running build_ext
building ‘MySQLdb.mysql’ extension
creating build/temp.macosx-10.9-universal2-cpython-311
creating build/temp.macosx-10.9-universal2-cpython-311/MySQLdb
clang -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -arch arm64 -arch x86_64 -g -Dversion_info=(2,1,1,’final’,0) -D__version
=2.1.1 -I/opt/homebrew/Cellar/mysql/8.0.33/include/mysql -I/Library/Frameworks/Python.framework/Versions/3.11/include/python3.11 -c MySQLdb/_mysql.c -o build/temp.macosx-10.9-universal2-cpython-311/MySQLdb/_mysql.o -std=c99
clang -bundle -undefined dynamic_lookup -arch arm64 -arch x86_64 -g -L/opt/homebrew/opt/zlib/lib build/temp.macosx-10.9-universal2-cpython-311/MySQLdb/_mysql.o -L/opt/homebrew/Cellar/mysql/8.0.33/lib -L/opt/homebrew/opt/[email protected]/lib -lmysqlclient -lzlib -lresolv -o build/lib.macosx-10.9-universal2-cpython-311/MySQLdb/_mysql.cpython-311-darwin.so
ld: library not found for -lzlib
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command ‘/usr/bin/clang’ failed with exit code 1
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
ERROR: Failed building wheel for mysqlclient
Running setup.py clean for mysqlclient
Failed to build mysqlclient
ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects`

I have tried:

1.
Hey. I have an error when try to install mysqlclient to my Django project on Mac

2.

Assume you are activating Python 3 venv

$ brew install mysql $ pip install mysqlclient
3.

Assume you are activating Python 3 venv

$ brew install mysql-client $ echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile $ export PATH="/usr/local/opt/mysql-client/bin:$PATH" $ pip install mysqlclient

I see this:
sudo apt-get install python3-dev default-libmysqlclient-dev build-essential
but I have a Mac so it doesn’t solve my problem.

2

Answers


  1. After installing zlib, you need to set the DYLD_LIBRARY_PATH environment variable. Open a Terminal window and enter that command:

    export DYLD_LIBRARY_PATH=/usr/local/lib:$DYLD_LIBRARY_PATH. 
    

    It will tells your system where to find the zlib library.

    Of course, if /usr/local/lib is not the path, change it

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search