this is how my database.js is
module.exports = ({ env }) => {
const client = env(“DATABASE_CLIENT”, “mysql”);
const connections = {
mysql: {
connection: {
connectionString: env(“DATABASE_URL”, “”),
host: env(“DATABASE_HOST”, “db”),
port: env.int(“DATABASE_PORT”, 3306),
database: env(“DATABASE_NAME”, “strapi”),
user: env(“DATABASE_USERNAME”, “strapi”),
password: env(“DATABASE_PASSWORD”, “somepasswordgoeshere”),
ssl: env.bool(“DATABASE_SSL”, false) && {
key: env(“DATABASE_SSL_KEY”, undefined),
cert: env(“DATABASE_SSL_CERT”, undefined),
ca: env(“DATABASE_SSL_CA”, undefined),
capath: env(“DATABASE_SSL_CAPATH”, undefined),
cipher: env(“DATABASE_SSL_CIPHER”, undefined),
rejectUnauthorized: env.bool(
“DATABASE_SSL_REJECT_UNAUTHORIZED”,
true
),
},
},
pool: {
min: env.int(“DATABASE_POOL_MIN”, 2),
max: env.int(“DATABASE_POOL_MAX”, 10),
},
}
};