How we can deploy the Flask Application using Managed Database on Digital Ocean server

October 18, 2019 302 views
Clustering Python Frameworks MySQL Python DigitalOcean

Can you please confirm how we can pass the ssl mode required variable under the Flask application.
I am using the Managed MYSQL database instance it’s connected successfully with my local database, but when I am using the same thing with Digital Ocean managed database level then it’s giving me an error related to SSl mode required options.
Please help me to resolve this issue.

1 Answer

Hey @rahularoraengg,

your config should contain a connection string for the database such as;

SQLALCHEMY_DATABASE_URI = 'mysql://user:pass@hostname/database?ssl_mode=REQUIRED'

It may be necessary to also use the other SSL option(s) but add them to the URI config line.

Have another answer? Share your knowledge.