How do I access a mysql managed db via mysql2 from node.js

Heya,

No an expert here but Try adjusting your dbConfig to add rejectUnauthorized: true explicitly. This ensures strict verification.

const dbConfig = {
    host: process.env.MYSQL_HOST,
    user: process.env.MYSQL_USER,
    password: process.env.MYSQL_PASSWORD,
    database: process.env.MYSQL_DATABASE,
    port: process.env.MYSQL_PORT,
    ssl: {
        ca: process.env.CA_CERT, // Your CA certificate content
        rejectUnauthorized: true, // Ensures the client validates the server's certificate
    },
};

and make sure CA_CERT environment variable contains the full content of your downloaded CA certificate.

export CA_CERT=$(cat /path/to/ca-certificate.pem)

Hi there,

You’ve already added the CA certificate to your environment variable, which is great! Now, you need to tweak your ssl configuration slightly to ensure Node.js trusts the certificate chain.

Here’s the updated configuration for your dbConfig:

const dbConfig = {
    host: process.env.MYSQL_HOST,
    user: process.env.MYSQL_USER,
    password: process.env.MYSQL_PASSWORD,
    database: process.env.MYSQL_DATABASE,
    port: process.env.MYSQL_PORT,
    ssl: {
        rejectUnauthorized: true,
        ca: process.env.CA_CERT,
    },
};

Let me know how it goes!

- Bobby