Problem Connecting To Mysql Server Remotely
StormLiong
Join Date: 2002-12-27 Member: 11569Members
Join Date: 2002-12-27 Member: 11569Members
in Off-Topic
<div class="IPBDescription">Hope someone can help here</div> I've been having problems trying to connect to my MySQL server remotely. Here are some notes and issues of it
For security reasons and argrument sake consider my server ip is 255.255.255
1. The server comp is a windows 2000 server
2. I can connect to the MySQL server locally.
3. I use MySQLFront most of the time (I can only use it locally of course cos of the problem).
3. Port 3306 is definitely being listened by MySQL (checked it tthrough fport)
4. Skip_Networking variable is definitely off.
5. When Telnet-ting to it <b>locally(on teh server computer itself)</b> by typing in teh command "open 255.255.255 3306", it says it cant connect. This of course doesnt work also when i do it remotely.
With all this in mind, can anyone give me their opinion what is it that I can do to get this problem fixed.
Thank you so much for any help given. <!--emo&:D--><img src='http://www.unknownworlds.com/forums/html/emoticons/biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif'><!--endemo-->
For security reasons and argrument sake consider my server ip is 255.255.255
1. The server comp is a windows 2000 server
2. I can connect to the MySQL server locally.
3. I use MySQLFront most of the time (I can only use it locally of course cos of the problem).
3. Port 3306 is definitely being listened by MySQL (checked it tthrough fport)
4. Skip_Networking variable is definitely off.
5. When Telnet-ting to it <b>locally(on teh server computer itself)</b> by typing in teh command "open 255.255.255 3306", it says it cant connect. This of course doesnt work also when i do it remotely.
With all this in mind, can anyone give me their opinion what is it that I can do to get this problem fixed.
Thank you so much for any help given. <!--emo&:D--><img src='http://www.unknownworlds.com/forums/html/emoticons/biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif'><!--endemo-->
Comments
- Windows firewall is turned off
- or all the relevant ports are not protected
It's under 'Networking Advanced Settings' I believe
Sorry if this doesn't make much sense :-) I'm a linux person meself