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.