I am trying to connect with Workbench MySQL from my laptop to 1 click droplet with workbench but I cannot get a connection. I tried both the Droplet IP as well as the floating IP. I am not using (installed) SSH for simplicity. I am using standard TCP and tried as root and other users but no luck.
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!
Is this a Managed Database on Digital Ocean Digital Ocean does not have any help regarding connection from workbench to Managed Database. This is very annoying
Hello,
I believe that your MySQL port is closed via your firewall so that’s why you are not able to access it remotely.
What you could try doing is allowing your IP address and then try to connect again. You could do that with the following command:
sudo ufw allow from your.home.ip.here
Then check the status:
sudo ufw status
Hope that this helps! Regards, Bobby
Hi, mysql server is listening to 127.0.0.1 by default. so try to use this as MySQLHost
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.