Warning: mysqlirealconnect(): (HY000/3159): Connections using insecure transport
-
to optimize my wordpress install performance, I Set Up a Remote Database with MySQL on Ubuntu 16.04. I have also set up a separate web server to host the wordpress install. The remote MSQL database can only be connected over SSL. During server configuration, the remote users on the web server have been successfully connected to the mysql server .
I downloaded wordpress onto the web server. However when i attempt to run the wordpress install from browser, I get this error (wordpress debug mode set to true):- Warning: mysqlirealconnect(): (HY000/3159): Connections using insecure transport are prohibited while –requiresecuretransport=ON. in /var/www/html/wp-includes/wp-db.php on line 1538
What is causing this error and How do I fix this error?
The page I need help with: [log in to see the link]
-
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 1538See this article by your host, Digital Ocean: see How To Configure SSL/TLS for MySQL on Ubuntu 16.04
MySQL 5.7 and up require that if you set configuration option –require_secure_transport=ON, clients are REQUIRED to use “secure” transport.
In this context, “secure” connections can be SSL/TLS, Socket, or Shared Memory and MySQL will reject new connections which do not use one of these three connection types.
But as you say you’re able to make the remote connection outside of the WordPress environment, I’m not really sure WordPress is doing differently.
UPDATE: I can see the connection is working now. Would you mind sharing what change you made?
- The topic ‘Warning: mysqlirealconnect(): (HY000/3159): Connections using insecure transport’ is closed to new replies.