Connecting to a remote host

[MrBelfry]

Hey there

I'm sure this is a question that will have come up before but the tek-tips search engine seems to be slightly messed up at the minute so I'm asking it again!

I'm developing a PHP script to update a table on a remote machine. I can connect easy enough but only if I add the % wildcard as a host - to my mind this makes things less secure. How can I get mysql to accept connections from my machine bearing in mind i'm on dial up

Thanks

MrBelfry

http://www.mrbelfry.co.uk

http://www.lighthousecc.co.uk

http://www.imagemagazine.co.uk

 

[sleipnir214]

If you're coming in through dialup, then your IP address is dynamically assigned. As such, you can't lock down your login to a single IP address.

The best you can do is to find out what range of IP addresses your ISP is assigning to dialup, and set the host for that user to a limited wildcard which spans that range.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[MrBelfry]

Forgive me for being stupid

I tried a variation of that technique but may have been doing things wrong. Here is what I tried to accept wildcard entries when the user was me

my_name@%

This didn't seem to work can anyone point me in the right direction

MrBelfry

http://www.mrbelfry.co.uk

http://www.lighthousecc.co.uk

http://www.imagemagazine.co.uk

 

[ingresman]

Can

http://www.easydns.com

help you out with thier dynamic dns service ?