Question
How do I open port 3306 with ufw?
I just got finished installing mysql on my droplet. I have set up and opened ports 80,443,(ssh) without a hiccup. My only problem now is that even though my droplet says that 3306 is open, I can’t connect to it outside of ssh. It says that 3306/tcp is set to allow ANYWHERE but I still can’t connect to it, even after a complete restart.
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.
×
Just an FYI, you should not forward MySQL outside of the machine it is on, especially not to 0.0.0.0
something else not mentioned here is that you need to ensure that your mysql users GRANT PRIVILEGES commands allow the IP / hostnames you connect in through
On this case, I was testing an mysql client to manage a non production database. Though this was back in January.