Hi! I've been using phpMyAdmin for managing databases on our server but needed another tool. I tried several I found HeidiSQL to be en great tool that suits our needs. Great!
I need to connect to our server using the SSH tunnel. This is working, but I have one issue:
We use a directadmin server to host sites and their db's. In the settings of a database we can set 'Access Hosts'. All databases have set 'localhost' as allowed 'Access Host'.
When I set up the SSH tunnel using 'localhost' this is somehow 'translated' to IP ::1. I believe this is the IPv6 equivalent to 127.0.0.1 (IPv4). But our database server does not allow '::1' to coneet. Only 'localhost.
So we get this error:
Access denied for user 'dbusername'@'::1' (using password: YES)
When I add ::1 to the 'Access Hosts' of a database the connection can be made. But this means I would need to add this IP to all our databases on the server. This is a lot of work.
Why is 'localhost' not send by HeidSQL? Or rather plink.exe? Does plink.exe change localhost to ::1?
I contacted ourr hosting provider to see if this might be an issue on our server but the say the server is expecting the hostnam 'localhost' but is send the ::1 IP.
Is there a way for me to use localhost without needing to add ::1 to all our databases 'Access Host' on our server?