I have confirmed that I have SSL remote connections working (tested from the command line mysql-client remotely).
I can't for the life of me figure out how to make this work from PHP land though. I am novice when it comes to encryption.
This is my connection script:
# Init SQL Link
$con = mysqli_init();
The error reported to me is:
Warning: mysqli_real_connect(): (HY000/1044): Access denied for user 'myusername'@'myservername' to database 'mydatabase' in /var/www/html/public_html/test.php on line 39
I have the following SSL files (which I believe were generated via command line utility mysql_ssl_rsa_setup)
Would anyone happen to know which of these and in which order I use them in mysql_ssl_set()?
Please and thank you so much. No amount of Googling has lead me to the answer and I suspect it's due to me not understanding how the Encryption works OR not understanding how my webhost has configured their mysql-client.