Connect WordPress to Azure MySQL DB using a secure connection.

Few months back I decided to move Titan Fusion to Azure. I installed and configured an instance of WordPress on an Azure VM, but for security and performance reasons I decided to use an instance of Azure Database for MySQL to host the site’s database separately. After updating wp-config.php with the database configuration, WordPress was not able to connect to the remote database. After doing few tests and reviewing Microsoft’s documentation, I was able to determine that Azure database instances require a secure connection by default. There are ways to disable this requirement, but the better option is to simply tell WordPress to use a secure connection to the database. Especially when it is supported!

To enable secure database connections in WordPress simply add the lines below to your database configuration in the wp-config.php file.

/** Azure MySQL database requires SSL connection. */
define( 'DB_SSL', true );
define( 'MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL );

Don’t cripple your website’s security by disabling encryption just because it is on the backend or inconvenient. Data in transit should always be encrypted.

Discover more from Titan Fusion

Subscribe now to keep reading and get access to the full archive.

Continue reading