Question
How do I connect to a Managed SQL Database from web apps?
- Posted June 9, 2020
- DigitalOcean Managed MySQL Database
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 (52.175.251.223) 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!
Best,
Ben
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.
Hello,
I believe that you just need the CA certificate. I have been using SQL clients to connect to the managed databases as expected.
Also what is the exact 3rd party tool that you are using? You might have to get in touch with them and check if they support connections to MySQL 8 servers.