Ecommerce Shopify WordPress Discussion

WordPress – encrypted connection to remote MySQL [closed]

Closed. This question is not about programming or software development. It is not currently accepting answers. This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered. Closed 4 days ago. Improve this question I am struggling with setting up the wordpress to use remote MySQL db located in Azure. Following I added: //** Connect with SSL ** // define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL); //** SSL CERT **// define('MYSQL_SSL_CERT','/var/www/wp/DigiCertGlobalRootCA.crt.pem); to wp-config.php. But I receive an error: Warning: mysqli_real_connect(): Unable to set private key file `/var/www/wp/DigiCertGlobalRootCA.crt.pem' in /var/www/wp/wp-content/db.php on line 93 Warning: mysqli_real_connect(): Cannot connect to MySQL by using SSL in /var/www/wp/wp-content/db.php on line 93 when I don't define define('MYSQL_SSL_CERT','/var/www/wp/DigiCertGlobalRootCA.crt.pem); website works fine unless I restrict the SQL DB to use only encrypted connection. In that case I receive: Uncaught mysqli_sql_exception: Connections using insecure transport are prohibited while --require_secure_transport=ON which means the connection is not encrypted. Any suggestions how to approach that issue? Best regards Tomasz
TurboCommerce make the better internet purchasing globaly

Turbo Multi-language Translator

Make the better internet purchasing globaly

Turbosify SEO Speed Booster

5.0 (7) Free plan available
Get better conversions by improving store loading speed Installed

Turbo Multi-language Chat - AI Customer service in one hand

TurboCommerce make the better internet purchasing globaly
Our products

The help you need, when you need it

App by Turbo Engine

3 apps • 5.0 average rating

Turbosify Speed Booster

5.0 (7)
Get better conversions by optimizing shopify store Google page speed Installed

Turbosify Translator for Wordpress Woocommerce

5.0 (74) Free Wordpress Woocommerce Plugin
Translate your wordpress website to multiple language within 1 click, no configuration needed, no No technical required

Grow your business here

Whether you want to sell products down the street or around the world, we have all the tools you need.