Managed Databases and Reporting on AWS / Microsoft

Posted June 2, 2021 72 views
MySQLDigitalOcean Managed MySQL Database

I am currently trying to analyze some data that I have on the managed MySQL database service. However trying to connect through either power bi / aws quicksight has been a real headache.

  • Connecting through power bi on Windows desktop out rightly fails. This is with the correct login details.

  • Connecting through quicksight outrightly fails with ssl enabled and soft fails without ssl enabled. The error without ssl enabled is Public Key Retrieval is not allowed.

Could someone kindly clarify on if it is possible to connect these 2 to a managed database on digital ocean?

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!