Frequently Asked Questions (FAQ)

Mac Users

1. MySQL Error

ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so, 2): Library not loaded: @rpath/libmysqlclient.21.dylib Referenced from: /Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so Reason: image not found

Add the following line to the ~/.bash_profile file

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/:$DYLD_LIBRARY_PATH

2. SSL Certificate Error

ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1056)

• Go to Macintosh HD
• Click on Applications
• Click on the Python3.7 folder (or whatever version of python you're using)
• Double click on "Install Certificates.command" file.

Click here if you installed python via homebrew.