我有 Python 3.8.8，mysql并mysql-client已安裝。我還安裝了mysql-connector-python==8.0.26與mysqlclient==2.1.0利用圖書館pip。
但是線
python -c "匯入 MySQLdb"
回傳此錯誤：
> Traceback (most recent call last):
File "/Users/louisgabilly/anaconda3/envs/venv/lib/python3.8/site-packages/MySQLdb/__init__.py", line 18, in <module>
from . import _mysql
ImportError: dlopen(/Users/louisgabilly/anaconda3/envs/venv/lib/python3.8/site-packages/MySQLdb/_mysql.cpython-38-darwin.so, 2): Symbol not found: _mysql_affected_rows
Referenced from: /Users/louisgabilly/anaconda3/envs/venv/lib/python3.8/site-packages/MySQLdb/_mysql.cpython-38-darwin.so
Expected in: flat namespace
in /Users/louisgabilly/anaconda3/envs/venv/lib/python3.8/site-packages/MySQLdb/_mysql.cpython-38-darwin.so
>
>During handling of the above exception, another exception occurred:
>
>Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/Users/louisgabilly/anaconda3/envs/venv/lib/python3.8/site-packages/MySQLdb/__init__.py", line 24, in <module>
version_info, _mysql.version_info, _mysql.__file__
NameError: name '_mysql' is not defined
我相信這個錯誤是由于 MacOS M1。
uj5u.com熱心網友回復：
即使您已經安裝了mysqlclient，您也需要安裝 Oracle 本機客戶端庫才能使其作業。您可以使用 brew 安裝客戶端。
brew install mysql-client
uj5u.com熱心網友回復：
因為這個答案說 MySQLdb 不支持 Python 3 你應該匯入
import mysql.connector
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/401010.html
標籤：Python mysql 苹果系统 mysql-python