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

Posted October 18, 2019 3.4k views
MySQLDigitalOceanPythonPython FrameworksClustering

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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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.