Sorry for this question but i would like find the solution.
I have a linux ubuntu server on remote machine with public ip 100.200.300.400.
In this remote machine i have a docker with MySql container with name “mysql_container” with port expose 3306:3306 and listen on 0.0.0.0 and user with % host.
In my windows database client i have this configuration:
host 100.200.300.400
port 3306
user
password
I can connect without problem.
But this is not good for security (connection with public ip) and i would like set my container for connection with 127.0.0.1 and tunneling.
I my windows database client i have this configuration:
host 127.0.0.1
port 3306
user
password
Tunnel with dbeaver:
ssh host 100.200.300.400
local host empty
local port 3306
remote host 127.0.0.1
remote port 3306
No connection.
Tunnel with putty:
ssh host 100.200.300.400
L 3306 127.0.0.1:3306
No connection.
Please can you help me? Thank you