How do I connect to managed database?!

Hello,

I’m coming from AWS, so I’m getting pretty frustrated at how difficult it seems to be to just ssh into the managed database.

I don’t see any tutorials on how to ssh into the managed database or how to connect it to MySql workbench. What I do see is that almost every tutorial for remote connection says that I need to update to Mysql 8.

I don’t understand why I have to do this? The servers that are pulling from the managed database server shouldn’t have to be running the same version of Mysql as the managed database server. Am I missing something here?

I know I’m ranting, so I’ll narrow down my focus… What I’d just like to figure out is to how to connect to the database via Mysql Workbench - preferably without having to upgrade to Mysql 8.

DO provides this (public): username = doadmin password = [password] host = [host] port = 25060 database = defaultdb sslmode = REQUIRED

And the ca cert.

I enter this in Mysql Workbench: SSH Hostname = [host] SSH Username = doadmin SSH Password [password]

MySQL hostname = 127.0.0.1 Mysql Server Port = 3306 Username = root password =?? CA-Cert = [path to ca cert]

I’ve tried various configurations, but the closest I get is with the error: Authentication error. Please check that your username and password are correct and try again. Details (Original exception message): Bad authentication type, the server is not accepting this type of authentication. Allowed ones are: [u’publickey’]

Any help would be greatly appreciated.