Jump to content


Photo

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

ubuntu mysql

  • Please log in to reply
1 reply to this topic

#1 terungwa

terungwa
  • Members
  • PipPipPip
  • Advanced Member
  • 92 posts

Posted 02 December 2017 - 04:38 AM

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?

 



#2 terungwa

terungwa
  • Members
  • PipPipPip
  • Advanced Member
  • 92 posts

Posted 02 December 2017 - 08:35 AM

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

Reference:

https://stackoverflo...ration-possible

 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users