Can't connect to MySQL instance in managed databases
Managed MySQL instances were just released yesterday so I decided to spin one up to test it out. I have not been able to connect to the instance using any tool at my disposal. Running OSX 10.14.6
- Sequel Pro (nightly build) produces this error: MySQL said: SSL connection error: socket layer receive error
- TablePlus produces this error: SSL connection error: error:00000005:lib(0):func(0):DH lib
- MySQL cli using this command
mysql -u doadmin -*********** -h db-mysql-***-71474-do-user-******-0.db.ondigitalocean.com -P 25060 -D defaultdbproduces this error: ERROR 2026 (HY000): SSL connection error: error:00000000:lib(0):func(0):reason(0)
What is required in order to connect to this database? I’ve downloaded the CA Cert that was provided. I’ve installed that via Keychain. I’ve also provided it to Sequel Pro and TablePlus in the proper fields on the login dialogs. What am I missing? This doesn’t seem to be addressed in the connection docs (https://www.digitalocean.com/docs/databases/mysql/how-to/connect/) or the troubleshooting docs (https://www.digitalocean.com/docs/databases/mysql/resources/troubleshoot-connections/).
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.