Question

Remote access to MySQL not working after following a ton of tutorials. What am I missing?

Posted November 9, 2017 3.5k views
MySQL Firewall Ubuntu 16.04

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)

5 comments

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.

1 answer

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.

Submit an Answer