SSH tunnel for mysql

SSH tunnel

ssh -p 3333 -L local_port:remote_host:remote_port user@machine
 - after a connection to 'machine' is established, all tunneled connections will be directed to the 'remote_host'.
1. ssh -p 3333 -L 3307:localhost:3306 sbalamaci@machine1.ocean.digital
2. ssh -p 3333 -L 3307:82.67.89.3:3306 sbalamaci@machine1.ocean.digital
it matters to which mysql interface the bind is done. 

careful with testing the setup with mysql client connecting to 'localhost' as it will bypass network and connect through a socket file. So even if you messed the setup it will connect to a local mysql instance if available.

to be ran on server for desktop publishing.
x11vnc -safer -localhost -nopw -noxdamage -ncache 10 -once -display :0

ssh -p 3333 -L 5900:192.168.1.5:5900 user@masina