backend/knexfile.js

import "dotenv/config";

const base = {
  client: "mysql2",
  connection: {
    host:     process.env.DB_HOST,
    user:     process.env.DB_USER,
    port:     process.env.DB_PORT,
    password: process.env.DB_PASS,
    database: process.env.DB_SCHEMA,
    charset:  "utf8mb4"
  },
  migrations: {
    tableName: "knex_migrations",
    directory: "./db/migrations"
  },
  seeds: {
    tableName: "knex_seeds",
    directory: "./db/seeds"
  }
};

export default {
  development: base,
  production:  { ...base, connection: { ...base.connection, ssl: { rejectUnauthorized: false } } }
};