connecting mysql onwin2k3 server from win98 client

hi i have just setup a windows server 2003. i am able to log onto the server with a windows 98 client, but when i attempt to connect to a database running on mysql on the windows server 2003, i get a message that it is unable to to connect to mysql.

can someone please advise.

thanks

 

By default, 2003 server will block the ports MySQL uses to connect to external clients such as MySQL Administrator. The port you need to allow traffic in on is 3306.

 

unblocking ports

hi Reggie
thanks for your message, could you let me know how to unblock port 3306?

many thanks

shak

 

I can't remember the exact location of the default block on 2003 (it is a long time since I reconfigured our server away from default). It is either of:

1. Go to Network connections in Control Panel. Right click on the LAN network connection and select Properties. Then click on the Advanced tab, and the Settings button. This will open the Firewall options. If they are enabled, you need to add an Exception for port 3306. I think it is TCP, but it won't hurt to create two exceptions, one for TCP and one for UDP. If the firewall options are not enabled, try the next option below.
2. Go to Network connections in Control Panel. Right click on the LAN network connection and select Properties. Select the "Internet Protocol(TCP/IP)" item in the list of network objects on the General tab. Click on the Properties button and then the Advanced button. Go to the Options tab, make sure "TCP/IP filtering" is highlighted and click on the Properties button. Add rules for the 3306 ports (TCP and UDP) to allow traffic to pass.

 

will try it

thats great Reggie, will give it a go.
just a not about something i found, when i checked the status of port 3306 on the server, it said 0.0.0.0:3360 listening 1700.
when i checked the status of port 3360 on a work station it came up with TIME_WAIT - have you come across that before?

I tired the second option as the windows firewall is inactive, and when i got to the packt filtering section in TCP/IP packet filtering was disabled, but it was set to permit all.

thanks for your assistance

thanks

shka

 

The correct port is 3306.

3306 is the port of the service. The client will use a random port above 1024. So when on connect from the Windows 98 PC (the client), it will connect TO port 3306 on the server, but the FROM port will be a random port: possibly 2330, or 2321. The FROM port will be different each time as connection session is initiated. So the windows 98 PC will only have a process listening on port 3306 if it is running the MySQL database as well, or you happen to pick a rare occasion when 3306 happens to be the random port.

So it looks like filtering isn't the problem. How are you trying to connect to the MySQL database from the Windows 98 PC? What are you trying to do?

 

connecting mysql on windows server 2003

hi Reggie
i am not too sure of the functionality of the mysql setup, that is something that the developer is taking care of. he seems to have figured out what the issue was and developed and updated .exe file that needs to be copied onto all the client machines.
if you would like to know what he did i will be more than happy to ask and pass the information onto you. but it does sound like it was some sort of mysql setup issue and not windows.

just like to say many thanks for your assistance on the topic.

Kind Regards

shak

 

Don't worry. I'm just glad the problem is solved.