How to create self host with docker create environment connect mysql planetscale with SSL

Questions
,
1

services:
n8nio-n8n:
image: “n8nio/n8n”
restart: on-failure
ports:
- “80:5678”
environment:
DB_MYSQLDB_DATABASE: xxxxxxxx
DB_MYSQLDB_HOST: aws.connect.psdb.cloud
DB_MYSQLDB_PASSWORD: xxxxxxxxxx
DB_MYSQLDB_PORT: 3306
DB_MYSQLDB_USER: xxxxxxxxxxxxxxx

How to set DB_MYSQLDB_SSL OR DB_MYSQL_URL

2

DATABASE_URL=‘mysql://:@aws.connect.psdb.cloud/?ssl={“rejectUnauthorized”:true}’

or how append “?ssl={“rejectUnauthorized”:true}” on environment

3

Hey @bkk.pyu,

Welcome to the community :cake:

If the database is using a trusted certificate it should work but at the moment we don’t have the SSL options for MySQL. This is something we do have Postgres though which might be a better option if you are setting up a new environment.