We have a Windows Server 2003 machine with MySQL installed, and a Windows XP client machine. On the client machine we have a C++ application. Windows firewall is active on both machines.
We opened port 3306 on client and server machines for database connection. When we want to check database connectivity from the C++ application, the server responds very slowly. We googled about it and on the MySQL forums someone said that when he opened both ports 3306 and 65000 on the client machine in a similar situation the server responds quickly.
But no one confirms that port 65000 should be opened. We tested port 65000 and our server has started to respond quickly.
What should we do in this situation? Any help will be appreciated.