Question
Can't connect with MySQL workbench
- Posted on August 28, 2019
- OpenLiteSpeed WordPress 1-Click
Asked by jpippo
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!
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.
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
Hi, mysql server is listening to 127.0.0.1 by default. so try to use this as MySQLHost
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:
Then check the status:
Hope that this helps! Regards, Bobby