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
After installing zlib, you need to set the DYLD_LIBRARY_PATH environment variable. Open a Terminal window and enter that command:
It will tells your system where to find the zlib library.
Of course, if
/usr/local/lib
is not the path, change itIt seems mysql 8.0.33 issue -> https://github.com/Homebrew/homebrew-core/issues/130258
UPDATE: i solved install -> https://formulae.brew.sh/formula/mariadb