add MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT to MYSQL SSL connnection

Found the answer, so I am turning this question into a suggestion.

In short, SSL to MySQL on a remote server won't work unless you add MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT to the connection in src/XF/Db/Mysqli/Adapter.php, as I have here:

$isConnected = @$connection->real_connect(
$config['host'], $config['username'], $config['password'],
$config['dbname'], $config['port'] ?: 3306, $config['socket']...
Click to expand...

Read more

Читать далее...