Can't connect to managed databse mysql usign SEQUEL PRO

Posted on November 27, 2020

MySQL

DigitalOcean Managed MySQL Database

By rcolnago2

I followed some docs without success. MySQL said: Access denied for user ‘root’@‘localhost’

Does any one has a tutorial on how to connect to the database using SEQUEL PRO or other MySQL mac client?

Cheers

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!

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.

Bobby

November 29, 2020

Hi there @rcolnago2,

In order to connect, you need to launch Sequel Pro, then under the Standard tab add your database details. You should not use SSH as the Managed databases do not come with SSH access.

Under the Standard tab add the database details:

Host - > this should be the hostname of your Managed database cluster
Username - > the username for your database cluster, by default it should be doadmin
Password - > the password for your cluster
Database - > the name of your database, by default it is defaultdb
Port - > here make sure to specify the Managed database cluster port, by default it is 25060

Once you have your information in there, click on the Connect button.

Let me know how it goes. Regards, Bobby