Re: mysql remote connection fails

[Manikandan Ehambaram]

Hi, I had the same problem, I actually opened the port from Windows Firewall and afterthat I am able to connect to my server from remote client but only through other users otherthan root.

Steps to open the port from Firewall

1. Go to ControlPanel/Windows Firewall
2. Select Exception TAB
3. Select "Add Port..", Give MySQLServer as Name and 3306 as Port and make sure TCP is selected
4. If you more want to restrict this port within your local network (hosts with IP 192.168.0.X) select Change Scope... and choose "My Network (Subnet only)

Create a new user and assign some schema previlates to the new user from MySQL Administration tool and use this new user from remote machine.

Hope this helps
Mani