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 crimple you website’s security by disabling encryption just because it is on the backend or inconvenient. Data in transit should always be encrypted.