Connecting remotely to MYSQL on dynamic IP

[dataconnects]

Hi,
I have a DSL connection (with dynamic IP address) and run MYSQL on the machine. I try to connect to it from work/outside but has not been successful so far. I usually do 'ipconfig' to know the current IP address which I supply on the command line but it doesn't help.

I would be appy if anybody can describe how can connect to it from other machine(s).

Thanx

 

[tshot]

u can grant permission with start netowrk part of ur ip address
as GRANT ALL ON <YrDb> tTO<user>@192.168.128.%
u can also give like user@192.168.128.0/17. This implies that client hso has 192.168.128 in first 17 bits of ip address and so has 17 bit network number

if the system complains about % or / chars then quote user and ip address separately i.e. user@'192.168.128.0/17'. or
'user'@'192.168.128.0/17'.




----------------
ur feedback is a very welcome desire