I’ve set bind address to 0.0.0.0 and now have
mysqld 270434 mysql 24u IPv4 1223739 0t0 TCP *:3306 (LISTEN)
If I nc -vc [ip] 3306 I always get operation timed out.
I’ve tried commenting out bind address, changing it to *, tried all the same with mysqlx-bind-address too but can’t connect to the server at all.
No firewall enabled
Any ideas?
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!
Hello,
Setting the bind-address to 0.0.0.0 is indeed correct.
As you don’t have a firewall enabled on the MySQL Droplet, do you by any chance have a firewall on the server/PC that you are connecting from? If this is the case you might have to open port 3306 for outgoing TCP connections.
Alternatively, what I prefer doing is to connect to my remote MySQL servers over SSH with Table Plus as described here:
https://tableplus.com/blog/2019/08/ssh-tunnel-secure-database-connection.html
That way you don’t have to expose the MySQL service to the world.
Let me know how it goes! Regards, Bobby
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.