Quote:


@ Kihaku:

Have you tried finding your internal ip address?
--> run command prompt: ipconfig




Yep i did that and i cant connect to my internal IP


Quote:


Have your tried finding your external ip address?
--> try Whatismyip.com




Did that too before


Quote:


Are you behind a router?
--> forward port 3306 to the internal ip address of the computer running mysql server




yeah im behind a router. BUT do i need to forward the IP if i use my internal IP as host?


Quote:


Are you behind a firewall?
--> accept inbound/outbound on port 3306 on the computer running mysql server




Yep i do, i even closed the firewall to test it.


Quote:


Have you made changes to the server allowing inbound/outbound connections?

Example Computer A
Name: SQL
Internal IP: 192.168.11.22
External IP: 213.10.104.17
MySQL DB Server listening on port: 3306

Example Computer B
Name: DEV
Internal IP: 192.168.11.33
External IP: 213.10.104.17

If you have only 1 computer, no router and it's connected directly to the internet then you do not have to do anything. This because when you try connecting to 213.10.104.17:3306 it would go straight to your computer, unless you have a firewall running in the background. If this is the case you must allow to accept remote connections.

In the case you have 1 or more computer connected via a router to the internet then you must forward port 3306 on the router to the internal ip address of the computer running the mysql server, in the example that would be 192.168.11.22 otherwise the router doesn't understand how to handle it and time-out.

Anyways I have posted a reply to your previous post in user contribution forum. I think if you try to connect with the script from Michael_Schwarz to Freesql.org and it works, then it must be a problem with router, firewall or both. Some firewall don't shutdown the Windows XP firewall so it's actualy still active and prevent inbound connections from anywhere else then localhost or 127.0.0.1, therefore you must allow XP firewall to accept inbound connections on port 3306 too.

To end, if you don't have a domain or don't want to pay for using one. Maybe you can register one for free at DynDNS, this way you do not have to enter your external ip address to connect to your database, webserver or gameserver, but you can use your personal domain name instead.

Dusty



I tried it with 3 webservers from me. but i never could connect to one, so i guess i have some mistakes in the mysql config, since the www.freesql.org domain works for me. i will try it out a bit more

but i wonder if i really have to forward the port when i use my internal IP to connect to my database on the PC.. shouldnt it work even without portforwarding?


Thanks a lot for your nice help

My Blog

"Tag und Nacht schrei ich mich heiser,
Wind weht alle Worte fort,
Tag und Nacht schrei ich mein Krähenwort!"
Subway To Sally - Krähenkönig