Question

How do i get the root password for a managed database in my account?

Posted December 22, 2021 103 views
DigitalOcean Managed MySQL Database

I need the root password for my DO MySQL managed database?

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.

×
Submit an Answer
1 answer

Hi @dbellRay,

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. This means you don’t have a root user or any other user with that much privileges.

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

by Mark Drake
If you're new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We'll also explain how to use these programs to connect to a managed database instance.