Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
265 views
in Technique[技术] by (71.8m points)

python - Mysql database problem with django and vscode

!'m working on creating website with tools like vs code, django, mysql(using macos).
I was trying to connect my database to phpmyadmin with mamp but couldn't. Then I tried to connect to mysql workbench and that was working. However, I think that I broke something because I couldn't run my program... Instead I got the following error:

:django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.

Finally when I tried to install mysqlclient and mysql to my venv I got an error like below:

ERROR: Command errored out with exit status 1: command: /Users/arincatlamaz/Documents/praca-inzynierska/env/bin/python3 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-install-u2k_b6t6/mysqlclient_49a2127f669a431ab48f7a11e2a071cd/setup.py'"'"'; file='"'"'/private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-install-u2k_b6t6/mysqlclient_49a2127f669a431ab48f7a11e2a071cd/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"' '"'"', '"'"' '"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record /private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-record-uph0htiy/install-record.txt --single-version-externally-managed --compile --install-headers /Users/arincatlamaz/Documents/praca-inzynierska/env/include/site/python3.8/mysqlclient cwd: /private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-install-u2k_b6t6/mysqlclient_49a2127f669a431ab48f7a11e2a071cd/ Complete output (118 lines): running install running build running build_py creating build creating build/lib.macosx-10.14.6-x86_64-3.8 creating build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/init.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/exceptions.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/connections.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/converters.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/cursors.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/release.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb copying MySQLdb/times.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb creating build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/init.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/CR.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/ER.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.14.6-x86_64-3.8/MySQLdb/constants running build_ext building 'MySQLdb.mysql' extension creating build/temp.macosx-10.14.6-x86_64-3.8 creating build/temp.macosx-10.14.6-x86_64-3.8/MySQLdb xcrun -sdk macosx clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -iwithsysroot/System/Library/Frameworks/System.framework/PrivateHeaders -iwithsysroot/Applications/Xcode.app/Contents/Developer/Library/Frameworks/Python3.framework/Versions/3.8/Headers -arch arm64 -arch x86_64 -Dversion_info=(2,0,2,'final',0) -D__version=2.0.2 -I/usr/local/Cellar/mysql/8.0.22_1/include/mysql -I/Users/arincatlamaz/Documents/praca-inzynierska/env/include -I/Library/Developer/CommandLineTools/Library/Frameworks/Python3.framework/Versions/3.8/include/python3.8 -c MySQLdb/_mysql.c -o build/temp.macosx-10.14.6-x86_64-3.8/MySQLdb/_mysql.o In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:32: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/cdefs.h:807:2: error: Unsupported architecture #error Unsupported architecture ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:33: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/machine/_types.h:34:2: error: architecture not supported #error architecture not supported ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:52: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:55:9: error: unknown type name '__int64_t' typedef __int64_t __darwin_blkcnt_t; /* total blocks / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:56:9: error: unknown type name '__int32_t' typedef __int32_t __darwin_blksize_t; / preferred block size / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:57:9: error: unknown type name '__int32_t' typedef __int32_t __darwin_dev_t; / dev_t / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:60:9: error: unknown type name '__uint32_t' typedef __uint32_t __darwin_gid_t; / [???] process and group IDs / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:61:9: error: unknown type name '__uint32_t' typedef __uint32_t __darwin_id_t; / [XSI] pid_t, uid_t, or gid_t*/ ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:62:9: error: unknown type name '__uint64_t'; did you mean 'uint64_t'? typedef __uint64_t __darwin_ino64_t; /* [???] Used for 64 bit inodes / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/_types/_uint64_t.h:31:28: note: 'uint64_t' declared here typedef unsigned long long uint64_t; ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:52: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:68:9: error: unknown type name '__darwin_natural_t' typedef __darwin_natural_t __darwin_mach_port_name_t; / Used by mach / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:70:9: error: unknown type name '__uint16_t' typedef __uint16_t __darwin_mode_t; / [???] Some file attributes / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:71:9: error: unknown type name '__int64_t' typedef __int64_t __darwin_off_t; / [???] Used for file sizes / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:72:9: error: unknown type name '__int32_t' typedef __int32_t __darwin_pid_t; / [???] process and group IDs / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:73:9: error: unknown type name '__uint32_t' typedef __uint32_t __darwin_sigset_t; / [???] signal set / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:74:9: error: unknown type name '__int32_t' typedef __int32_t __darwin_suseconds_t; / [???] microseconds / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:75:9: error: unknown type name '__uint32_t' typedef __uint32_t __darwin_uid_t; / [???] user IDs / ^ /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types.h:76:9: error: unknown type name '__uint32_t' typedef __uint32_t __darwin_useconds_t; / [???] microseconds */ ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:53: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types/_intptr_t.h:30: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/machine/types.h:37:2: error: architecture not supported #error architecture not supported ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:45: In file included from /Library/Developer/CommandLineTools/usr/lib/clang/12.0.0/include/stdint.h:52: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/stdint.h:53: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/_types/_intptr_t.h:32:9: error: unknown type name '__darwin_intptr_t' typedef __darwin_intptr_t intptr_t; ^ In file included from MySQLdb/_mysql.c:29: In file included from /usr/local/Cellar/mysql/8.0.22_1/include/mysql/mysql.h:46: In file included from /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/sys/types.h:81: /Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include/machine/endian.h:37:2: error: architecture not supported #error architecture not supported ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. error: command 'xcrun' failed with exit status 1 ---------------------------------------- ERROR: Command errored out with exit status 1: /Users/arincatlamaz/Documents/praca-inzynierska/env/bin/python3 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-install-u2k_b6t6/mysqlclient_49a2127f669a431ab48f7a11e2a071cd/setup.py'"'"'; file='"'"'/private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-install-u2k_b6t6/mysqlclient_49a2127f669a431ab48f7a11e2a071cd/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(file);code=f.read().replace('"'"' '"'"', '"'"' '"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record /private/var/folders/f4/yc2ncr0515q7xw3yx9ztjjpm0000gn/T/pip-record-uph0htiy/install-record.txt --single-version-externally-managed --compile --install-headers /Users/arincatlamaz/Documents/praca-inzynierska/env/include/site/python3.8/mysqlclient Check the logs for full command output.`

Do you have some sugestion to solve this problem?
Thanks for the help!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...