Ssh mysql port forwarding

ssh -N -f -L 3336:127.0.0.1:3306 [USER]@[SERVER_IP]

The options used are as follows:

-N - Tells SSH not to execute a remote command.
-L 3336:127.0.0.1:3306 - Creates a local port forwarding. The local port (3306), the destination IP (127.0.0.1) and the remote port (3306) are separated with a colon (:).
[USER]@[SERVER_IP] - The remote SSH user and server IP address.

To run the command in the background, use the -f option.
If the SSH server is listening on a port other than 22 (the default) specify the port with the -p [PORT_NUMBER] option.

Source: linuxize.com

Similar codes

2 votes132 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote130 views1 answer
Generate random data postgresql
SQL
0 vote158 views1 answer
When mysql server would not work in xampp
SQL
0 vote127 views1 answer
Database xml sql
SQL
1 vote145 views2 answers
Setval max id postgresql sequence
SQL
0 vote145 views3 answers
Postgres date difference seconds
SQL
0 vote127 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote136 views1 answer
Sub query in linq
SQL
0 vote158 views1 answer
Shortcut run sql pgadmin
SQL
0 vote129 views1 answer
Write sql query to show the details start from digit
SQL