Differences

This shows you the differences between two versions of the page.

--- v5:database:mysql [2025/06/01 13:21] – Remove square brackets in tags dregad
+++ v5:database:mysql [2026/01/30 03:48] (current) – [Connecting With SSL] mnewnham
@@ Line 54: / Line 54: @@
 </code>
 ==== Connecting With SSL ====
-From ADOdb version 5.21, you can make an SSL connection to MySQL in the following way:
+From ADOdb version 5.23.10, you make an SSL connection to MySQL in the following way:
 <code php>
@@ Line 64: / Line 64: @@
 * Set the SSL parameters
 */
-$db->ssl_key    = "key.pem";
+$db->setConnectionParameter('ssl',[
-$db->ssl_cert   = "cert.pem";
+    'key' => "key.pem",
-$db->ssl_ca     = "cacert.pem";
+    'cert' => "cert.pem",
-$db->ssl_capath = null;
+    'ca' => "cacert.pem",
-$db->ssl_cipher = null;
+    'capath' => null,
+    'cipher' => null
+    ]
+);
 /*
@@ Line 88: / Line 91: @@
 $password = 'Qzrt6r55geRt!';
-$db->ssl_ca     = '/opt/azure-cert/DigiCertGlobalRootCA.crt.pem';
+$db->setConnectionParameter(
+    'ssl',
+    [
+     'ca'=>'/opt/certs/DigiCertGlobalRootG2-combined.crt.pem'
+    ]
+);
+$db->setConnectionParameter(
+    'clientflags', MYSQLI_CLIENT_SSL_VERIFY_SERVER_CERT
+);
 /*
 * Open the connection