Enabling Secure Connection To Remote Database

See if this helps: https://laracasts.com/discuss/channels/laravel/how-do-i-connect-to-a-mysql-database-over-ssl-with-laravel-53?page=1

You need to point to the ssl cert in the options array of the db connection.

Get rid of the 'encrypt' => 'yes'. That's bad info. It'd use true anyway if it were a real option instead of 'yes'.

It'd look something like:

'mysql' => [
    .............
    'options'   => [
        PDO::MYSQL_ATTR_SSL_KEY => '/path/to/client-key.pem',
        PDO::MYSQL_ATTR_SSL_CERT => '/path/to/client-cert.pem',
        PDO::MYSQL_ATTR_SSL_CA => '/path/to/ca-cert.pem',
    ],
],

I tried adding all this but still nothing. I'm also getting a new 500 error:

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php on line 122

I am stumped on this one. I have a local DB set up and that one works fine if I update the .env file. So I don't think it's a bad query.

Okay so I fixed this weird 500 error. Details here:

https://stackoverflow.com/questions/49136944/laravel-fatal-error-memory-bytes-exhausted-with-remote-database

And as @Cronix pointed out, I did need to add these options. I needed this setup:

'options' => array(
    PDO::MYSQL_ATTR_SSL_CA => '/var/lib/mysql/cert.pem',
    PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
),