DigitalOcean Database Connection

[eba8]

After running some more tests I was able to isolate the problem.
It leads me to this thread:

Unable to start ghost in docker with mysql on digitalocean

I am using the image ghost:3.35.5-alpine with the database client mysql. I am using mysql database from digitalocean and I getting an error which preventing the container from starting. [2020-10-18 21:19:29] ERROR create table `migrations_lock` (`lock_key` varchar(191) not null, `locked` boolean default '0', `acquired_at` datetime null, `released_at` datetime null) default character set utf8mb4 - UNKNOWN_CODE_PLEASE_REPORT: Unable to create or change a table without a primary key, when the syst…

Any recommendations on a database that would work with Ghost? Looks like DigitalOcean wasn’t a good choice for Ghost with a managed db.