Warning: mysqli_real_connect(): (HY000/3159): Connections using insecure transport are prohibited while --require_secure_transport=ON

[terungwa]

I have Set Up a Remote Database to Optimize wordpress Site Performance with MySQL on Ubuntu 16.04. I downloaded the wordpress onto my web server. When I Navigate to the public IP address associated with my web server, i get "Error establishing a database connection".

With wordpressdebug mode set to true, the details of the error is:

 

Warning: mysqli_real_connect(): (HY000/3159): Connections using insecure
transport are prohibited while --require_secure_transport=ON. in /var/www
/html/wp-includes/wp-db.php on line 1538

 

I have tested remote connection using the remote user and I am able to connect. This means my database server is running and my remote user credentials are also correct.

What may be causing this and how can I resolve this?

 

[terungwa]

adding this function below to my wp-config.php solved the problem: define('DB_SSL', true);

Reference:

https://stackoverflow.com/questions/7142632/wordpress-ssl-mysql-is-this-configuration-possible