How do I connect to a Managed SQL Database from web apps?
I am trying to connect to a Managed SQL database instance of mine from 3rd part web apps such as [https://www.retool.com/].
I have whitelisted the IP address of Retool (220.127.116.11) and to connect using SSL I need to enter a Client Key and a Client Cert.
Reading through the documentation: [https://www.digitalocean.com/docs/databases/mysql/how-to/connect/] I can connect to the database using either the MySQL command line from my droplet or from MySQL Workbench, but it is unclear to me how to retrieve the Client Key and the Client Cert so I can log in from a 3rd party tool.
Is this even possible with a Managed Database?
Any help would be greatly appreciated!
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.×