MilosZ: Created page with "Run from server you wanna access to MySQL that is on private network
that is not in same network as we are.

 $ ssh -v -4 -N -L 3307::3306 root@..."

2022-01-26T11:26:11Z

Created page with "Run from server you wanna access to MySQL that is on private network<br> that is not in same network as we are. <pre> $ ssh -v -4 -N -L 3307:<sql_server_private_ip>:3306 root@..."

New page

Run from server you wanna access to MySQL that is on private network<br>
that is not in same network as we are.
<pre>
$ ssh -v -4 -N -L 3307:<sql_server_private_ip>:3306 root@<remote_host>
$ mysql -h127.0.0.1 -p3307
</pre>

If we wanna make connection persistent and auto reconnect:
<pre>
$ autossh -M 0 -f -q -N -o "ServerAliveInterval 60" -o "ServerAliveCountMax 3" \
-L 3307:<sql_server_private_ip>:3306 root@<remote_host>
</pre>

Port forward mysql on local network with SSH - Revision history

MilosZ: Created page with "Run from server you wanna access to MySQL that is on private network
that is not in same network as we are.
$ ssh -v -4 -N -L 3307::3306 root@..."

Port forward mysql on local network with SSH - Revision history

MilosZ: Created page with "Run from server you wanna access to MySQL that is on private network that is not in same network as we are. $ ssh -v -4 -N -L 3307::3306 root@..."

MilosZ: Created page with "Run from server you wanna access to MySQL that is on private network
that is not in same network as we are.
$ ssh -v -4 -N -L 3307::3306 root@..."