Hi,
how is it possible to connect to webserver with 3dgs? I mean i use this MySQL dll from User Constribution, and i own the Pro + newest update. But i only can connect to a database on the PC itself, and only when i use "localhost". it doesnt even work when i use my IP adress from my pc...
Do i have to activate something first in 3dgs to use this? oO

I think you have to configure the MySQL server to accept external connections.

i think XAMPP allready opens everything, and my firewall is turned off.

i tried to connect to 3 different servers from me, and even on my own PC with my IP. doesnt work. only when i use localhost or 127.0.0.1, then it works.

Hm try installing the MySQL on your Server with the Hostadress Localhost and then try connecting to it over the domain ip. This is how my Server MySQL database is setup.

@ Blackmamba:

You don't have to call the computer where you install the MySQL database server 'localhost' You can call it whatever you like. The name localhost is the same on every computer so you can type localhost, 127.0.0.1 both works. Running the SQL server on the name localhost or ip address 127.0.0.1 is always a smart thing to do for security reasons.

@ Kihaku:

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

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

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

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

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

okay i came a bit closer.
i did following now:

go to database "mysql" and table "user"
found "root"
changed host from "localhost" to "%"
in shell did: "mysql -u root -p flush-privileges"
entered password
worked.
now i can connect to my database ON the pc with my internal IP, which is my external too (im at the university right now).
though i can't connect from outside now (maybe cause of the router, who knows) but im a step closer now.

EDIT:
okay, everything works perfect now. there were some firewall issues so i couldnt connect from outside, but from inside.

thanks again for this great help. the main problem was the user table in the mysql database

@ Kihaku:

Good to hear you have everything working now


Dusty