I have a mysql server which is accessed locally by several computers on the network through a static ip at 192.168.1.# . I need the mysql server to be accessed from our web servers so that I can run data syncs via the website backend. I have setup a dyndns address to follow the public ip of our network, and configured the firewall to port forward the port of our router to the mysql server. This is working correctly, as I was seeing the access requests getting stopped by my shorewall rules on the mysql server machine. If I remove all the firewall protection (temporarily) on the mysql server machine to test that I can access the machine properly, I still cannot access it, the connection just times out. I don't know what else I would need to set on the mysql server to allow for this access.
My mysql user table allows for my user to access the db from any host.
My my.cnf file sets the mysqld to bind-address=192.168.1.# and disables skip-networking
I've been working and searching for a fix for several days. Any help, links, or suggestions would be greatly appreciated.
If any other info would be helpful, I'd be happy to provide anything to get this working today. Thanks for looking and hopefully the assistance.
Best Answer
Side note: for the love of merlin's beard - Make sure you use SSL or stunnel