Question

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.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

I had this exact issue, and upgrading MySQL Workbench to 8+ worked as expected. Basic connection and I am good to go.

Hi @aflores, the managed database servers do not come with SSH access as this is the point of the servers being managed, you just use them as MySQL servers and connect via MySQL only.

You can follow the official step by step instructions on how to connect to the managed MySQL servers here:

https://www.digitalocean.com/community/tutorials/how-to-connect-to-managed-database-ubuntu-18-04#connecting-to-a-managed-mysql-database