Tangible Bytes

A Web Developer’s Blog

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)

  lots of lines here

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.