Error While Creating Sql Engine Using Sqlalchemy - Image Not Found

I'm testing a small python code When I try to create an engine that connects with MySQLDB I face the following error: statement: engine = create_engine(connection_url, echo=False,s

Solution 1:

I believe you are working with MacOS, error you have posted is due to incorrect installation of MySQL and MySQLdb package. Try the following instruction to fix MySQLdb and then try again:

brew install mysql
brew unlink mysql
brew install mysql-connector-c
sed -i -e 's/libs="$libs -l "/libs="$libs -lmysqlclient -lssl -lcrypto"/g' /usr/local/bin/mysql_config
pip install MySQL-python
brew unlink mysql-connector-c
brew link --overwrite mysql
pip install MySQL-python

Let me know if this helps.