I've changed bind-address to 0.0.0.0 and today changed it to the IP of my server which still doesn't work. The MySQL user I'm trying to connect with has host set as % and I've of course restarted MySQL a bunch of times. To test if the connection works I'm using XAMPP for windows and running "mysql -h SERVERIP -u user -p" to see if I can connect which it cannot. (Error 10060)
MySQL is a plaintext protocol, do not expose it to the internet and use it over a SSH tunnel instead.
Hmm yes true. It's probably really easy to monitor the traffic and find the details I use. I'll look into how to secure this. This project I'm working on is really small and will mostly be passed to a few friends at best but I'm using this as a learning experience so I will want to have it as secure as possible.
Yeah well I do need to look into how to get a SSH tunnel working with C# and I also lack experience with SSH overall but I'm sure there are many examples out there.
Have you checked if you have a firewall running
For example in Ubuntu you can run
I think it's correct. https://i.gyazo.com/185106e96229ea1291646321186324aa.png
That will be it,
The default is to deny all incoming. And you don't have a rule for MySQL Port 3306.
Please note this is not adviced to open MySQL to the whole internet. If you need this and can, you could limit to a fixed IP on the firewall
Thank you so much! This solved it.
Your welcome,
Please listen to mine and @Woet advice though and don't do this.
MySQL is not going to be secured.