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

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.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.