Home / server / Questions / 778393
In Process
Anadi Misra
Asked: 2016-05-23 19:28:23 +0800 CST

enabling ssl connection from wordpress to mysql

  • 772

I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic

my wordpress version is 4.5.2 and obviusly the code and settings is nothing like what I in examples all over forums, is there a more relevant example on how to fix settings in wp-settings.php and wp-includes/wp-db.php to ensure secure connection to a remote MySql?

ssl wordpress php56 mysql5.5

4 Answers

  1. Edit wp-config.php

    Add following line:

    define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL);

    If your database(MySQL 5.6 or later) use a self-assigned certificate, you may try:

    define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);

    Tested on WordPress version 5.2.

    • 7

  2. For those looking for a way to do this w/o hacking core or rolling your own plugin:

    https://wordpress.org/plugins/secure-db-connection/

    Created by the dev who initially reported the issue in WordPress: https://core.trac.wordpress.org/ticket/28625

    • 2
    • 0

  4. Pretty sure this is answered best here you basically add a filter, and the details to the SSL certificate details in wp-config.php

    There is also a plugin on the wordpress.org repository here

    • -1