Connect Strapi to Digital Ocean Managed Mysql
Connecting Strapi to a Digital Ocean Managed Mysql database required jumping through a couple of hoops
The managed database is available over SSL using a custom CA certificate
In order to connect, Strapi has to have the following environment variables:
(expressed here in YAML because my system runs in kubernetes)
DATABASE_SSL: "true"
DATABASE_SSL_CA: |
-----BEGIN CERTIFICATE-----
lots of lines here
-----END CERTIFICATE-----
In addition I had to edit the Digital Ocean Database user to use Legacy - MySQL 5.x password encryption as it seems the Strapi mysql client doesn’t support the newer standard yet.