Your credentials will look different than a typical mysql install. Use your full hostname and username. Hostname will look like yoursystem.mysql.database.azure.com. Username will look like mysqladm@yoursystem.
You will need the certificate from <a href="https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt.pem" target="_blank" rel="noopener" class="mycode_url">CA certifications here</a> and it will need to be stored somewhere on your website's root. Remember this path
This is one of the few times that we will tell you to modify a file in users/*. In fact, you will have to keep an eye out in case we update DB.php to make sure to copy your modification to the file.
Add these two lines to the construct function
PDO::MYSQL_ATTR_SSL_CA => "d:\home\site\wwwroot\BaltimoreCyberTrustRoot.crt.pem", //replace with your path
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
It will look like this…
class DB { private static $_instance = null; private $_pdo, $_query, $_error = false, $_errorInfo, $_results=[], $_resultsArray=[], $_count = 0, $_lastId, $_queryCount=0; private function __construct($config = []){ if (!$opts = Config::get('mysql/options')) $opts = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET SESSION sql_mode = ''", PDO::MYSQL_ATTR_SSL_CA => "d:\home\site\wwwroot\BaltimoreCyberTrustRoot.crt.pem", PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false