Python寫入串連mysql失敗

標籤：bsp   framework   ons   logs   串連數   串連   blog   style   sql   

執行如下串連資料庫的語句：

engine = create_engine(‘mysql://root:[email protected]/stock?charset=utf8‘)

報錯如下：

ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/_mysql.cpython-35m-darwin.so, 2): Library not loaded: libmysqlclient.18.dylib  Referenced from: /Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/_mysql.cpython-35m-darwin.so  Reason: image not found

 

解決辦法：

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/lib/libmysqlclient.18.dylib

 

參考Stack Overflow：https://stackoverflow.com/questions/6383310/python-mysqldb-library-not-loaded-libmysqlclient-18-dylib

 

Python寫入串連mysql失敗