mac python3连接mysql_Mac OS X系统Python3连接Mysql

The directory '/Users/simon/Library/Caches/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.

The directory '/Users/simon/Library/Caches/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.

Collecting mysqlclient

Downloading https://files.pythonhosted.org/packages/6f/86/bad31f1c1bb0cc99e88ca2adb7cb5c71f7a6540c1bb001480513de76a931/mysqlclient-1.3.12.tar.gz (89kB)

100% |████████████████████████████████| 92kB 122kB/s

Installing collected packages: mysqlclient

Running setup.py install for mysqlclient ... error

Complete output from command /Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-install-l1_o52yl/mysqlclient/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('rn', 'n');f.close();exec(compile(code, __file__, 'exec'))" install --record /private/tmp/pip-record-zkfu3qn7/install-record.txt --single-version-externally-managed --compile:

running install

running build

running build_py

creating build

creating build/lib.macosx-10.9-x86_64-3.6

copying _mysql_exceptions.py -> build/lib.macosx-10.9-x86_64-3.6

creating build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/__init__.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/compat.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/connections.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/converters.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/cursors.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/release.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

copying MySQLdb/times.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb

creating build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/CR.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/ER.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

copying MySQLdb/constants/REFRESH.py -> build/lib.macosx-10.9-x86_64-3.6/MySQLdb/constants

running build_ext

building '_mysql' extension

creating build/temp.macosx-10.9-x86_64-3.6

gcc -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -arch x86_64 -g -Dversion_info=(1,3,12,'final',0) -D__version__=1.3.12 -I/usr/local/Cellar/mysql-connector-c/6.1.10/include -I/Library/Frameworks/Python.framework/Versions/3.6/include/python3.6m -c _mysql.c -o build/temp.macosx-10.9-x86_64-3.6/_mysql.o

gcc -bundle -undefined dynamic_lookup -arch x86_64 -g build/temp.macosx-10.9-x86_64-3.6/_mysql.o -L/usr/local/Cellar/mysql-connector-c/6.1.10/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.9-x86_64-3.6/_mysql.cpython-36m-darwin.so

ld: library not found for -lssl

clang: error: linker command failed with exit code 1 (use -v to see invocation)

error: command 'gcc' failed with exit status 1

----------------------------------------

Command "/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-install-l1_o52yl/mysqlclient/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('rn', 'n');f.close();exec(compile(code, __file__, 'exec'))" install --record /private/tmp/pip-record-zkfu3qn7/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-install-l1_o52yl/mysqlclient/