How do I connect to managed database?!
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
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:
Any help would be greatly appreciated.