database - How to resolve Connections using insecure transport are prohibited while --require_secure_transport=ON

admin管理员组

文章数量:1415145

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?

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?

• database

Share Improve this question asked Dec 1, 2017 at 20:01 TerungwaTerungwa 17111 gold badge33 silver badges1414 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

The quickest fix would be to go to sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf and remove the:

"requiresecuretransport = on"

Then restart via:

sudo systemctl restart mysql

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

Reference:

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

本文标签： databaseHow to resolve Connections using insecure transport are prohibited while requiresecuretransportON