mysqlclientをインストールしようとするとエラーが出る

PythonからMySQLを接続するためにmysqlclientをインストールしようと思い、
pip install mysqlclientをしたところ、

Collecting mysqlclient
Using cached mysqlclient-1.4.6.tar.gz (85 kB)
Building wheels for collected packages: mysqlclient
Building wheel for mysqlclient (setup.py) ... error
ERROR: Command errored out with exit status 1:
command: /Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/bin/python3.7 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/setup.py'"'"'; file='"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/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/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-wheel-x1_qwr3g
cwd: /private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/
Complete output (34 lines):
running bdist_wheel
running build
running build_py
creating build
creating build/lib.macosx-10.15-x86_64-3.7
creating build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/init.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/exceptions.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/compat.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/connections.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/converters.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/cursors.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/release.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/times.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
creating build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/init.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
running build_ext
building 'MySQLdb.mysql' extension
creating build/temp.macosx-10.15-x86_64-3.7
creating build/temp.macosx-10.15-x86_64-3.7/MySQLdb
clang -Wno-unused-result -Wsign-compare -Wunreachable-code -DNDEBUG -g -fwrapv -O3 -Wall -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -Dversion_info=(1,4,6,'final',0) -D__version=1.4.6 -I/usr/local/opt/mysql@5.6/include/mysql -I/Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/include -I/Users/takuma/.pyenv/versions/3.7.2/include/python3.7m -c MySQLdb/_mysql.c -o build/temp.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.o -g -fno-omit-frame-pointer -fno-strict-aliasing
MySQLdb/_mysql.c:1165:10: warning: case value not in enumerated type 'enum enum_field_types' [-Wswitch]
case 245: // JSON
^
1 warning generated.
clang -bundle -undefined dynamic_lookup -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/takuma/.pyenv/versions/3.7.2/lib -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/takuma/.pyenv/versions/3.7.2/lib build/temp.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.o -L/usr/local/opt/mysql@5.6/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.cpython-37m-darwin.so
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)

error: command 'clang' 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: /Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/bin/python3.7 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/setup.py'"'"'; __file__='"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/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/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-record-zq3lu3w3/install-record.txt --single-version-externally-managed --compile --install-headers /Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/include/site/python3.7/mysqlclient
     cwd: /private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/
Complete output (34 lines):
running install
running build
running build_py
creating build
creating build/lib.macosx-10.15-x86_64-3.7
creating build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/__init__.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/_exceptions.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/compat.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/connections.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/converters.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/cursors.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/release.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
copying MySQLdb/times.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb
creating build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.15-x86_64-3.7/MySQLdb/constants
running build_ext
building 'MySQLdb._mysql' extension
creating build/temp.macosx-10.15-x86_64-3.7
creating build/temp.macosx-10.15-x86_64-3.7/MySQLdb
clang -Wno-unused-result -Wsign-compare -Wunreachable-code -DNDEBUG -g -fwrapv -O3 -Wall -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -Dversion_info=(1,4,6,'final',0) -D__version__=1.4.6 -I/usr/local/opt/mysql@5.6/include/mysql -I/Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/include -I/Users/takuma/.pyenv/versions/3.7.2/include/python3.7m -c MySQLdb/_mysql.c -o build/temp.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.o -g -fno-omit-frame-pointer -fno-strict-aliasing
MySQLdb/_mysql.c:1165:10: warning: case value not in enumerated type 'enum enum_field_types' [-Wswitch]
    case 245: // JSON
         ^
1 warning generated.
clang -bundle -undefined dynamic_lookup -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/takuma/.pyenv/versions/3.7.2/lib -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/takuma/.pyenv/versions/3.7.2/lib build/temp.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.o -L/usr/local/opt/mysql@5.6/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.15-x86_64-3.7/MySQLdb/_mysql.cpython-37m-darwin.so
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command 'clang' failed with exit status 1
----------------------------------------

ERROR: Command errored out with exit status 1: /Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/bin/python3.7 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/setup.py'"'"'; file='"'"'/private/var/folders/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-install-cbp3t6gj/mysqlclient/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/5m/nbqwwlv56651jgbyjwnvgxb40000gn/T/pip-record-zq3lu3w3/install-record.txt --single-version-externally-managed --compile --install-headers /Users/takuma/.pyenv/versions/3.7.2/envs/py372tensorflow/include/site/python3.7/mysqlclient Check the logs for full command output.
とエラーが表示されてしまいました。

Pythonバージョン　3.7.2
macOSです

試したこと...brew install mysqlをした後にpip install mysqlclientをしてもこのエラーが表示されました。

quickquip

2020/03/19 01:21 編集

・ビルドの手順が書かれていない(mysqlの指定とかしてませんか?) ・ログが読めるようになっていない(書式指定になってしまうので、コード扱いにしてもらった方が読みやすいです https://teratail.com/help/question-tips#questionTips3-5-1 ) ので、そのあたりを編集してもらうのがよいかと。

hoshi-takanori

2020/03/23 02:00

エラーは ld: library not found for -lssl で、mysql に含まれる ssl ライブラリが見つからなくてエラーになってるようです。で、brew install mysql したら最新版の 8 が入るはずですが、-L/usr/local/opt/mysql@5.6/lib が指定されてるのが怪しい気がします。mysql@5.6 も入ってたりしますか？