Warning: mysqli_real_connect(): (HY000/3159): Connections using insecure transport are prohibited while --require_secure_transport=ON
I followed this tutorial here “https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql-on-ubuntu-16-04” to Set Up a Remote Database with MySQL on Ubuntu 16.04.
I have also download 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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.