Cannot connect to a local mysql db with sqlalchemy on windows machine
I ran into a similar error involving tx_isolation.
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1193, "Unknown system variable 'tx_isolation'")
This was due to using an old version of SQLAlchemy.
pip install --upgrade SQLAlchemy
I was running off v1.0.15, upgrading to v1.2.9 fixed the error for me. I am also using the
mysql+pymysql connection setting as mentioned above.