View connection IP

johnny's profile image johnny posted 2 years ago in Creating a connection Permalink


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, 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.


ansgar's profile image ansgar posted 2 years 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


Ethernet-Adapter Ethernet:

   Verbindungsspezifisches DNS-Suffix:
   Verbindungslokale IPv6-Adresse  . : fe80::4f1a:3cf9:...
   IPv4-Adresse  . . . . . . . . . . : <<--
   Subnetzmaske  . . . . . . . . . . :
   Standardgateway . . . . . . . . . :
johnny's profile image johnny posted 2 years 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.