WampServer

I am trying to create a remote website that will be useing my WAMP5 databases untill I am done creating it but It refuses to allow my remote scripts to access the DB even though I have set you a username with the remote IP as host.

Any help please?

Hi,

Does your firewall/router allow requests coming in from the internet with the destination TCP port 3306 through? You need to set up the port forwarding for TCP port 3306, forwarding these requests to the internal IP address of your WAMP server. Once you have that working, you can then limit the source IP address of these requests to the external IP address of your remote website, if your firewall/router allows you to do that.

Regards,



toivo
Sydney, Australia

my firewall is configured correctly to allow connections from that IP on that port.

Hi,

The request coming to the MySQL server may not present the IP address but the computer name and the domain,so that the user info looks like

username@ web01.example.com

where web01 is the computer name of the server sending the request and example.com is the domain where the computer is located.

Regards,



toivo
Sydney, Australia

HUH? Not completly getting you

Hi,

In the above example:

username = the MySQL username you want the remote server to use when talking to your MySQL in your WAMP server

web01 = the name of the remote server (computer name or host name)

example.com = the domain name of the remote server

The host information is therefore web01.example.com. When you replace the components with the actual values from your remote server and its domain, you have the host you need to add under your MySQL user as a host so that you can assign access rights to the 'user' which connects from the remote server.

Regards,



toivo
Sydney, Australia

So your say something like this

'Dajax@mycompname.mjolnir.ath.cx'

???

Hi,

Yes, if:
- Dajax is the MySQL username in the db connect parameters of your script running in the remote server
- mycompname is the hostname of the remote server
- mjolnir.ath.cx is the remote domain.

Regards,



Post Edited (11-02-07 02:05)

toivo
Sydney, Australia

ok i think ive got it

thanx

my comp name is mjolnir-dbd####

I don't wanna say it all... cause idk if someone can use that info.... but
that would be my comp name, im just going off wht Microsoft is telling me

Hi,

Just to get it right, the hostname and the remote domain are attributes of the remote server where your PHP scripts are running, different from the computer name and domain where you host your WAMP server and the MySQL database.

Cheers,



toivo
Sydney, Australia

So would it work if instaid of the IP address for my remote site i put the domain name in the host area for the user?