However, If I don't use REQUIRE SSL and I bind require_secure_transport = ON, I can connect successfully.
So, I have few questions:
1- Is it possible to connect from shinyapps.io securely, and if yes ... How?
2- Is it OK to connect from shinyapps.io without require_secure_transport = ON, i.e. In a normal way "from a security point of view".
PS: I generate the SSL/TLS certificates and keys using sudo mysql_ssl_rsa_setup --uid=mysql. Also, I can connect from client-server using require_secure_transport = ON and without publishing the public key and certificates to that client-server.
@abubaker how are you connecting to your MySQL instance fromshinyapps.io?
Could you share the connection call, with the address, username and password redacted please.
Have you tried passing the CLIENT_SSL or CLIENT_SECURE_CONNECTION flags when constructing the connection?
And just to clarify a bit, you phrased some of your questions as "connect to shinyapps.io", but you are actually trying to attempt to "connect from shinyapps.io" to a remote database, correct?
I didn't try passing flags, or actually I wasn't aware that is possible. However, how I can pass flags inside dbPool.
Sorry for mistake, yes I would like to connect from shinyapps.io to a remote database in digital ocean.