Forums

SqlAlchemy and MySQL on PythonAnywhere

Hey guys!

I would like to know how I can make a connection to a local application using sqlalchemy and mysql from pythonanywhere. As in the example below: engine = create_engine('postgresql://{user}:{passwd}@{host}/{database}')

Sure! Have a look at this articles and let us know how you get on!

https://help.pythonanywhere.com/pages/UsingMySQL/ <-- your connection string will be the same as the one used by web2py

https://help.pythonanywhere.com/pages/UsingSQLAlchemywithMySQL/

This might be helpful for development https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere