View connection IP

johnny's profile image johnny posted 1 year ago in Creating a connection Permalink

Hello,

How do you see which local IP HeidiSQL is using for the connection string? I'm trying to whitelist the IP of my local machine on the remote server, but need to know which one to use.

P.S. I have tried tools like whatsmyip.org, etc. but I'm behind a firewall and it doesn't always show the "true" IP of my machine. I hoping HeidiSQL logs this somewhere so I can see.

Thanks!

ansgar's profile image ansgar posted 1 year ago Permalink

No, the local IP is not logged in HeidiSQL.

You can use a terminal and fire "ipconfig" to find your local IP:

PS C:\> ipconfig

Windows-IP-Konfiguration


Ethernet-Adapter Ethernet:

   Verbindungsspezifisches DNS-Suffix: fritz.box
   Verbindungslokale IPv6-Adresse  . : fe80::4f1a:3cf9:...
   IPv4-Adresse  . . . . . . . . . . : 192.168.123.123 <<--
   Subnetzmaske  . . . . . . . . . . : 255.255.255.0
   Standardgateway . . . . . . . . . : 192.168.188.1
johnny's profile image johnny posted 1 year ago Permalink

Yes, I tried that as well but it's not showing the address I need. I connect via a VPN and there's some intermediary IP address that needs to be whitelisted. I did get the correct IP from our support team, but I was tiring to find a way to get it through HeidiSQL or some other query.

Thanks for your help!

Please login to leave a reply, or register at first.