Linode Managed Mysql with AAPanel Connection Issue
I am having a issue with added my Linode Managed Mysql DB cluster to AAPanel as a remote database server. I enter all the information correct. I have access controls setup to allow the private IP of my Linode instance. The instance and the DB Cluster are in the same datacenter (Dallas) however I get the following error:
(3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')
I have searched all over to find help and have come up empty. I know this is in regard to the DB Cluster using TLS/SSL encryption. What do I need to do to get this to work?
Thanks in advance!
You may want to try downloading the CA certificate file from the Database page in cloud manager and connect using the
--ssl-mode=VERIFY_CA --ssl_ca=<Path to ca.pem file> options in your connection string. You can find more information on these options in the MySQL Documentation.
The MySQL Forums are another resource you could use to potentially find the answer.