Allow remote connections?

[uberamd]

So I have MySQL 5 installed on my server, when I installed it I checked the box to allow root remote access, I set root's access flags to 'root@%' and yet I cannot connect to my database server from the outside. My router forwards port 3306 to 10.4.1.100 (my local server's IP), I can do a portscan and it says I have an application running on the port, yet I am unable to connect.

I just get an error when trying to connect with my VB app saying it cannot connect to any of the specified hosts. No firewall is running, it is a Windows 2000 server OS system.

Can someone tell me how to allow remote MySQL connections in Windows? If I change the bind_ip to the external IP of the server the process wont even start! Any ideas?

 

[munkee]

Your host my block access to it via 3rd party applications. I had this problem with one of my servers and decided to change companies because I needed my application(s) to access this.

I'm still working with getting the whole VB.NET / MySQL thing worked out - hopefully I can come up with something here soon! haha